Skip Headers
USER_ROLE_PRIVS describes the roles granted to the current user.
USER_ROLE_PRIVS
USERNAME
VARCHAR2(30)
Name of the user, or PUBLIC
PUBLIC
GRANTED_ROLE
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)
ADMIN OPTION
YES
NO
DEFAULT_ROLE
Indicates whether the role is designated as a DEFAULT ROLE for the user (YES) or not (NO)
DEFAULT ROLE
OS_GRANTED
Granted by the operating system (YES) or not (NO); occurs if configuration parameter OS_ROLES = true.
OS_ROLES
true