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