USERIDEM_USER_PRMPTVW(SQL View) |
Index Back |
|---|---|
Local Admin Auth. UsersMarketPay Security This SQL view will limit access by a local administrator only to user profiles that share his/her BU permissions. Since it is returning a list of User OPRIDs, the SQL view must use the Local Administrator's ROWSECCLASS. Caveat: The Local Administrator's ROWSECCLASS must contain a value equal to his/her USERID |
| SELECT DISTINCT A.OPRID ,C.OPRDEFNDESC FROM PS_SEC_BU_OPR A ,PS_SEC_BU_OPR B ,PSOPRDEFN C ,PSROLEUSER D ,PS_EM_ROLE_CONFIG E WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.OPRID <> B.OPRID AND A.OPRID = C.OPRID AND A.OPRID = D.ROLEUSER AND D.ROLENAME = E.EM_ROLENAME AND E.EM_ROLETYPE IN ('05', '10', '15', '20') |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | USERID |
Character(30) | VARCHAR2(30) NOT NULL | A user's ID |
| 2 | OPRDEFNDESC | Character(30) | VARCHAR2(30) NOT NULL | Description field for a user |