SQL query to find out list of users who have access to a Page and information on which Permission list enables the user to access the page:
SELECT DISTINCT oprid, 
                oprclass 
FROM   psoprcls 
WHERE  oprclass IN (SELECT DISTINCT classid 
                    FROM   psauthitem 
                    WHERE  pnlitemname = :1) 


This query can be modified as below to see if a user has access to a particular component and if yes through which permission list.

SELECT DISTINCT oprid, 
                oprclass 
FROM            psoprcls 
WHERE           oprclass IN 
                             ( 
                             SELECT DISTINCT classid 
                             FROM            psauthitem 
                             WHERE           pnlitemname = :1--required component name) 
AND             oprid = :2      --required userid

How to Query Which Components Are Accessed by Which Roles?
For example, for component "JOB_DATA", to find out which role should be given to a user which gives them access to that component or page use the following SQL.
SELECT * 
FROM   psauthitem A, 
       psroleclass B, 
       psroleuser C 
WHERE  A.baritemname IN ( :1 ) 
       AND A.classid = B.classid 
       AND C.rolename = B.rolename 
       AND C.roleuser = 'PS' 

PeopleTools Tables - Part 3 - PeopleTools records for basic definitions in PeopleSoft Application Designer

After PeopleTools Tables - Part 1 - PeopleTools table for PS-Queries, and PeopleTools Tables - Part 2 - PeopleTools records for Security Definition the next set of PeopleTools records is here related to basic PeopleSoft object definitions related to Application development.

Record for Projects:
  1. PSPROJDEFNLANG - Project Definition Lang Table
  2. PSPROJECTDEFN        - Project Definition Table
  3. PSPROJECTDEP - Incident Dependency Table
  4. PSPROJECTINC - Project Incidents Table
  5. PSPROJECTITEM - Project Item Table Here are couple of my posts on PSPROJECTITEM Part 1 and Part 2 which will help in understanding PSPROJECTITEM record. Here is another post on PSPROJECTITEM record which explains querying PSPROJECTITEM data and extracting it to spreadsheet
  6. PSPROJECTMSG - Project Messages
  7. PSPROJECTSEC

Record for Fields:
  1. PSDBFIELD - A table with all Database Fields
  2. PSDBFIELDLANG - Alternate language for PSDBFIELD table
  3. PSDBFLDLABL - DBField Label Table where FIELDNAME represents DBField name while LABEL_ID is a unique ID of Field Label.
  4. PSDBFLDLABLLANG - DBField Label Language Table
  5. PSXLATITEM - Translate Value Items

Record for Records:
  1. PSRECDEFN - Record header table
  2. PSRECFIELD - Fields in the record (subrecords not expanded)
  3. PSRECFIELDALL - Fields in the record (subrecords expanded)
  4. PSKEYDEFN - Indexes
  5. PSTBLSPCCAT - Tablespaces
  6. PSRECTBLSPC - Records’ tablespace assignments
  7. PSRECDEFNLANG
Record for Indexes:
  1. PSINDEXDEFN
Record for Pages:
  1. PSPNLDEFN - Page header table
  2. PSPNLFIELD - Page controls 
  3. PSPNLHTMLAREA - Static HTML Areas on Pages
Record for Components:
  1. PSPNLGRPDEFN - Component header table
  2. PSPNLGROUP - Pages in the components
  3. PSPNLGDEFNLANG
  4. PSPNLGROUPLANG
Record for Component Interfaces:
  1. PSBCDEFN - header record; one row for each Component Interface
  2. PSBCITEM - one row for each property
  3. PSAUTHBUSCOMP - Component Interfaces access table. Links Permission Lists, Component Interfaces, Methods and Authorized Actions
Record for Menus:
  1. PSMENUDEFN - Menu header table
  2. PSMENUITEM - Items (components) on the menu

PeopleTools Tables - Part 2 - PeopleTools records for Security Definition

After PeopleTools Tables - Part 1 - PeopleTools table for PS-Queries, the next set of PeopleTools records is here related to PeopleSoft Security.
Below is the complete list of PeopleTools meta tables that stores various information on PeopleSoft Security. These tables are specific to Tools version 8.50 and could vary slightly between versions.
  1. PSCLASSDEFN - Permission Lists definition. Master list of permission lists
  2. PSAUTHITEM - Authorized menu item. It contains list of Menu items granted security by permission lists. To find out permissions lists giving access to a component, search this record
  3. PSROLEDEFN - Role definition. Master table of Roles
  4. PSROLECLASS - Role Classes. Links Roles and associated Permission Lists
  5. PSOPRDEFN - Operator Definition. This is a core table for User Profile Manager which defines PeopleSoft users.
  6. PSROLEUSER - Roles granted to users. Links roles and users having access to.
  7. PSAUTHBUSCOMP - Component Interfaces access table. Links Permission Lists, Component Interfaces, Methods and Authorized actions
  8. PSUSEREMAIL - Email addresses for user ids.
  9. PSOPRCLS - Userids and their associated Permissions Lists
  10. PSAUTHPRCS - Link between permission lists and process groups
  11. PSAUTHSIGNON - Link between permission lists and signon times
  12. PSAUTHWEBLIBVW - A view linking permission lists and access to web libraries (menus in PSAUTHITEM that begin with WEBLIB_).
  13. PSAUTHWS - Link between permission lists and web services (service operations)
  14. PS_SCRTY_ACC_GRP - Link between permission lists, trees and query access groups
  15. PSSIGNONPPC - Signon Peoplecode
  16. PSAUTHCHNLMON - Message monitor Channel Security
  17. PSAUTHCUBE - Link between Permission lists and Cube Instance Ids
  18. PSAUTHOPTN - Link between Permission lists with User options and category levels
  19. PSAUTHQUEUEMON - Link between Permission lists and Queues
  20. PSAUTHWS - Authorized Web Services. Link between Permission lists and Service operation
  21. PSPRCSPRFL - Process Profile. Link between Permission lists with Server/client file/print options, Output destination details, Request status, Server status and Recurrence update details.
  22. PS_MC_OPR_SECURITY - Mass change operator security. Link between userid(oprid) and Mass Change Template
  23. PS_MC_OPRID - Mass change operator security. Link between operatorid(OPRID) and Online execution details
  24. PS_SCRTY_QUERY - PS Query profile. Links permission lists and various access levels in PS Query.
Records for USERS:
1.     PSOPRALIAS
2.     PSOPRDEFN
3.     PSROLEUSER
4.     PSUSERATTR
5.     PSUSEREMAIL
6.     PSUSERPRSNLOPTN
7.     PS_ROLEXLATOPR
8.     PS_ROLEXLATOPR_LNG
9.     PS_RTE_CNTL_RUSER

Records for ROLES:
1.     PSROLEDEFN
2.     PSROLEDEFNLANG
3.     PSROLECANGRANT
4.     PSROLECLASS

Records for PERMISSION LISTS
1.     PSCLASSDEFN
2.     PSAUTHBUSCOMP
3.     PSAUTHCHNLMON
4.     PSAUTHCUBE
5.     PSAUTHITEM
6.     PSAUTHOPTN
7.     PSAUTHQUEUEMON
8.     PSAUTHPRCS
9.     PSAUTHSIGNON
10.  PSAUTHWS
11.  PSPRCSPRFL
12.  PS_MC_OPR_SECURITY
13.  PS_MC_OPRID
14.  PS_SCRTY_ACC_GRP
15.  PS_SCRTY_QUERY