EOSU_ROLEGRNTVW(SQL View) |
Index Back |
---|---|
Grantable roles for user |
SELECT DISTINCT A.ROLEUSER , C.ROLENAME , C.DESCR , C.ROLE_PCODE_RULE_ON , C.ROLE_QUERY_RULE_ON , C.LDAP_RULE_ON FROM PSROLEUSER A , PS_EOSU_RVWD_ROLE E , PSROLEDEFN C WHERE A.ROLENAME = E.ROLENAME AND E.ROLENAME = C.ROLENAME |
# | 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 | ROLENAME | Character(30) | VARCHAR2(30) NOT NULL | The name of a Role in the Role Definition Table (see PSROLEDEFN). |
3 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
4 | ROLE_PCODE_RULE_ON | Character(1) | VARCHAR2(1) NOT NULL |
PeopleCode Rule Enabled
N=No Y=Yes |
5 | ROLE_QUERY_RULE_ON | Character(1) | VARCHAR2(1) NOT NULL |
Query Role Enabled
N=No Y=Yes |
6 | LDAP_RULE_ON | Character(1) | VARCHAR2(1) NOT NULL |
Directory Rule Enabled
N=No Y=Yes |