PSROLEGRANTVW

index back

Grantable roles for user


SELECT 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 NameField TypeColumn TypeDescription
OPRIDCharacter(30)VARCHAR2(30) NOT NULLA user's ID (see PSOPRDEFN).
ROLENAMECharacter(30)VARCHAR2(30) NOT NULLThe name of a Role in the Role Definition Table (see PSROLEDEFN).
DESCRCharacter(30)VARCHAR2(30) NOT NULLDescription
ROLE_PCODE_RULE_ONCharacter(1)VARCHAR2(1) NOT NULLPeopleCode Rule Enabled
N=No
Y=Yes
ROLE_QUERY_RULE_ONCharacter(1)VARCHAR2(1) NOT NULLQuery Role Enabled
N=No
Y=Yes
LDAP_RULE_ONCharacter(1)VARCHAR2(1) NOT NULLDirectory Rule Enabled
N=No
Y=Yes
index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
PTRef generated on 09-JUN-19