Header Ads

  • Recent Post

    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

    Please refrain for marketing messages and unnecessary back links.

    Post Top Ad

    Post Bottom Ad