| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
View PDF |
| Oracle® Database Reference 10g Release 1 (10.1) Part Number B10755-01 |
|
|
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. |
|
 Copyright © 2002, 2003, Oracle Corporation All Rights Reserved. |
|
