Static Data Dictionary Views, 475 of 521
USER_ROLE_PRIVS lists roles granted to the 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)
Granted with ADMIN option (YES | NO)
ADMIN
YES
NO
DEFAULT_ROLE
Role is designated as the user's default role (YES | NO)
OS_GRANTED
Granted by the operating system (YES | NO; occurs if configuration parameter OS_ROLES = TRUE)
OS_ROLES
TRUE