11/2/14

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

No comments:

Post a Comment

Please refrain for marketing messages and unnecessary back links.

Workflow errors on New Hire and Add employment instance

User tries to hire a new person or tries to add a new organization relationship encounters a series of error messages related to workflow...

Trending in this Blog this month