Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
|
|
View PDF |
USER_ROLE_PRIVS
describes the roles granted to the current user.
Column | Datatype | NULL | Description |
---|---|---|---|
USERNAME |
VARCHAR2(30) |
Name of the user, or PUBLIC |
|
GRANTED_ROLE |
VARCHAR2(30) |
Name of the role granted to the user | |
ADMIN_OPTION |
VARCHAR2(3) |
Indicates whether the grant was with the ADMIN OPTION (YES ) or not (NO ) |
|
DEFAULT_ROLE |
VARCHAR2(3) |
Indicates whether the role is designated as a DEFAULT ROLE for the user (YES ) or not (NO ) |
|
OS_GRANTED |
VARCHAR2(3) |
Granted by the operating system (YES ) or not (NO ); occurs if configuration parameter OS_ROLES = true . |