Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Go to next page
PDF · Mobi · ePub


USER_ROLE_PRIVS describes the roles granted to the current user.

Column Datatype NULL Description
USERNAME VARCHAR2(128)   Name of the user, or PUBLIC
GRANTED_ROLE VARCHAR2(128)   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)   Indicates whether the role was granted by the operating system (YES) or not (NO); occurs if the OS_ROLES initialization parameter is true
COMMON VARCHAR2(3)   Indicates how the grant was made. Possible values:
  • YES if the role was granted commonly (CONTAINER=ALL was used)

  • NO if the role was granted locally (CONTAINER=ALL was not used)

See Also: