PSPTADSRTPU_VW |
index back |
|---|---|
view to get privileged users |
| 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 | Field Type | Column Type | Description |
|---|---|---|---|
| CLASSID | Character(30) | VARCHAR2(30) NOT NULL | The name of the class (see PSCLASSDEFN). |
| ROLEUSER | Character(30) | VARCHAR2(30) NOT NULL | Role User |
| ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
| ACCESS_CD | Character(1) | VARCHAR2(1) NOT NULL |
Access Code
N=No Access Y=Read/Write Access |
| index back | (c)David Kurtz 2020, www.go-faster.co.uk | PeopleTools 8.58 PTRef generated on 21-DEC-20 |