PeopleSoft Security Tables
PeopleSoft Security is a very important part of PeopleSoft application. At first, it may look really complex but when you start learning, it's one of the most interesting topics to learn.
Here is a list of important PeopleSoft tables that are related to security. Keep this list handy to run queries and write SQLs to quickly extract information from PeopleSoft applications.
To make your job more easier, at the bottom of this post, you'll find a list of SQLs related to PeopleSoft security.
PeopleSoft Tables for PERMISSION LISTS
Table NAME | USE | IMPORTANT COLUMNS |
|---|---|---|
PSCLASSDEFN | Permission List Definitions | CLASSID, CLASSDEFNDESC |
PSROLECLASS | Roles associated with a Permission List | CLASSID, ROLENAME |
PSAUTHPRCS | Permission Lists associated with Process Groups | CLASSID, PRCSGRP |
PSOPRCLS | Permission Lists for a user profile | OPRID, OPRCLASS |
PeopleSoft Tables for ROLES
Table NAME | USE | IMPORTANT COLUMNS |
|---|---|---|
PSROLEDEFN | Role Definitions | CLASSID, CLASSDEFNDESC |
PSROLECLASS | Roles associated with a Permission List | CLASSID, ROLENAME |
PSROLEUSER | Roles assigned to a user | ROLENAME, ROLEUSER, DYNAMIC_SW |
PeopleSoft Tables for USER PROFILES
Table NAME | USE | IMPORTANT COLUMNS |
|---|---|---|
PSOPRDEFN | User Profile Details | OPRID, OPERPSWD,ACCTLOCK |
PSOPRCLS | Permission Lists for a user | OPRID,OPRCLASS |
PSROLEUSER | Roles assigned to a user | ROLENAME, ROLEUSER, DYNAMIC_SW |
PSACCESSLOG | User access details | OPRID, LOGIPADDRESS, LOGINDTTM, LOGOUTDTTM |
PeopleSoft Tables for MENU SECURITY
Table NAME | USE | IMPORTANT COLUMNS |
|---|---|---|
PSAUTHITEM | Menu associated with a permission list | CLASSID, MENUNAME |
PSMENUDEFN | Menu Definition | MENUNAME,MENULABEL |
PSMENUITEM | Details of menu items (e.g. component name) | MENUNAME, BARNAME,PNLGRPNAME |
PSPRSMDEFN | Other Menu Details | PORTAL_OBJNAME, PORTAL_LABEL |
PeopleSoft Tables for PROCESS SECURITY
Table NAME | USE | IMPORTANT COLUMNS |
|---|---|---|
PS_PRCSDEFN | Process Definition | PRCSNAME, PRCSTYPE |
PS_PRCSJOBDEFN | Joh Definition | PRCSJOBNAME, DESCR |
PSAUTHPRCS | Process group associated with a Permission List | CLASSID, PRCSGRP |
PS_PRCSJOBGRP | Job associated with process groups | PRCSJOBNAME, PRCSGRP |
PS_PRCSDEFNPNL | Processes in a process group | PRCSNAME, PNLGRPNAME |
You can use below SQLs to save time and extract PeopleSoft security related information quickly.
