Static Data Dictionary Views, 414 of 452
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
YES
NO
DEFAULT_ROLE
Role is designated as the user's default role: YES | NO
OS_GRANTED
Granted by the operating system: Y/N (occurs if configuration parameter OS_ROLES = TRUE)
OS_ROLES
TRUE