PSQuery Record Security

I’ve created a few PSQiueries and SQL statements to help clarify the current relationships between the Records, Roles and Users. Hopefully these can help you adjust security in your implementation so your PSQuery users have correct record access.
*Note: The SQL and Queries shown in this video have been updated with more efficient code. Updated code available on both the PeopleTools Tech Tips site and Github as linked below.

Jump to specific sections:
00:00 Intro
00:19 Overview
03:57 Review PSQueries for Record Access
06:14 X_PT3_QRYSEC_VW View
06:57 Strait SQL of Record Access
08:13 Wrap Up

Youtube link:    • PSQuery Record Security  
PeopleTools Tech Tips: https://peopletoolstechtips.com/psque...
Github: https://github.com/PeopleToolsTechTip...

Production Notes:
A PT3 Production
Presenter: Randall Groncki
Camera Kid: Anjelica Groncki

Music: Vlad Gluschenko — Overseas
License: CC BY 3.0: https://creativecommons.org/licenses/...
   / @vladgluschenkomusic