OPRIDMIN_CI_SEC_VW(SQL View) |
Index Back |
|---|---|
Component Interface securityComponent Interface security view returns method permissions based on the User ID Role Permission Lists |
| SELECT D.OPRID ,A.CLASSID ,D.OPRDEFNDESC , A.BCNAME ,A.BCMETHOD ,A.AUTHORIZEDACTIONS ,B.ROLENAME FROM PSAUTHBUSCOMP A , PSROLEUSER B , PSROLECLASS C , PSOPRDEFN D WHERE B.ROLENAME = C.ROLENAME AND B.ROLEUSER = D.OPRID AND A.CLASSID = C.CLASSID AND A.AUTHORIZEDACTIONS = 4 |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 2 | OPRCLASS | Character(30) | VARCHAR2(30) NOT NULL | Operator Class |
| 3 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |
| 4 | BCNAME | Character(30) | VARCHAR2(30) NOT NULL | Business Component Name (see PSBCDEFN). |
| 5 | BCMETHOD | Character(30) | VARCHAR2(30) NOT NULL | Method |
| 6 | AUTHORIZEDACTIONS | Number(10,0) | DECIMAL(10) NOT NULL | Authorized Actions for Panels |
| 7 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |