PSROLEGRANTVW

Return to Index

Grantable roles for user

PlatformView Text
DefaultSELECT DISTINCT A.ROLEUSER , B.GRANTROLENAME , C.DESCR , C.ROLE_PCODE_RULE_ON , C.ROLE_QUERY_RULE_ON , C.LDAP_RULE_ON FROM PSROLEUSER A , PSROLECANGRANT B , PSROLEDEFN C WHERE A.ROLENAME = B.ROLENAME AND B.GRANTROLENAME = C.ROLENAME

PeopleSoft Field NameDescription
OPRIDA user's ID
ROLENAMEThe name of a Role in the Role Definition Table
DESCRDescription
ROLE_PCODE_RULE_ONPeopleCode Rule Enabled
N=No
Y=Yes
ROLE_QUERY_RULE_ONQuery Role Enabled
N=No
Y=Yes
LDAP_RULE_ONDirectory Rule Enabled
N=No
Y=Yes

Author: PeopleTools

Return to Index

© Go-Faster Consultancy Ltd.  Last updated 24 July 2010