PSROLEGRANTVW |
| Platform | View Text |
|---|---|
| Default | 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 Name | Description |
|---|---|
OPRID | A user's ID |
ROLENAME | The name of a Role in the Role Definition Table |
| DESCR | Description |
| ROLE_PCODE_RULE_ON | PeopleCode Rule Enabled N=No Y=Yes |
| ROLE_QUERY_RULE_ON | Query Role Enabled N=No Y=Yes |
| LDAP_RULE_ON | Directory Rule Enabled N=No Y=Yes |
Author: PeopleTools | |
| Return to Index | © Go-Faster Consultancy Ltd. Last updated 24 July 2010 |