| Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-03  | 
  | 
  | 
View PDF | 
DBA_ROLE_PRIVS describes the roles granted to all users and roles in the database.
Related View
USER_ROLE_PRIVS describes the roles granted to the current user.
| Column | Datatype | NULL | Description | 
|---|---|---|---|
GRANTEE | 
VARCHAR2(30) | 
Name of the user or role receiving the grant | |
GRANTED_ROLE | 
VARCHAR2(30) | 
NOT NULL | 
Granted role name | 
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) | 
See Also:
"USER_ROLE_PRIVS"