Database Reference
ContentsOpens a new window
Opens a new window
Page 1814 of 2693

USER_ROLE_PRIVS

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)

DELEGATE_OPTION1Opens a new window

VARCHAR2(3)

 

Indicates whether the grant was with the DELEGATE 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:

"DBA_ROLE_PRIVSOpens a new window"

1Opens a new window

This column is available starting with Oracle Database 12c Release 1 (12.1.0.2).

Previous PageOpens a new window
Page 1814 of 2693
Next PageOpens a new window