PSPTADSRTPU_VW(SQL View) |
Index Back |
|---|---|
view to get privileged usersGet privileged users could bypass ADS record-access security settings |
| SELECT AI.CLASSID , RU.ROLEUSER , RU.ROLENAME , CASE WHEN AI.AUTHORIZEDACTIONS=4 THEN 'RW' WHEN AI.AUTHORIZEDACTIONS=1 THEN 'R' END FROM PSAUTHITEM AI , PSROLEUSER RU WHERE AI.MENUNAME='APPLICATION_DESIGNER' AND AI.BARNAME='UPGRADE' AND AI.AUTHORIZEDACTIONS IN (1, 4) AND AI.CLASSID IN ( SELECT DISTINCT A.CLASSID FROM PSROLECLASS A WHERE A.ROLENAME = RU.ROLENAME) GROUP BY AI.CLASSID, AI.AUTHORIZEDACTIONS, RU.ROLENAME, RU.ROLEUSER ORDER BY AI.CLASSID, AI.AUTHORIZEDACTIONS, RU.ROLENAME, RU.ROLEUSER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | CLASSID | Character(30) | VARCHAR2(30) NOT NULL | The name of the class (see PSCLASSDEFN). |
| 2 | ROLEUSER | Character(30) | VARCHAR2(30) NOT NULL | Role User |
| 3 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| 4 | ACCESS_CD | Character(1) | VARCHAR2(1) NOT NULL |
Access Code
N=No Access R=Read Only Access Y=Read/Write Access |