USER_SYS_PRIVS

USER_SYS_PRIVS describes system privileges granted to the current user.


Column Datatype NULL Description

USERNAME

VARCHAR2(128)

 

Name of the user, or PUBLIC

PRIVILEGE

VARCHAR2(40)

 

System privilege

ADMIN_OPTION

VARCHAR2(3)

 

Indicates whether the grant was with the ADMIN option (YES) or not (NO)

COMMON

VARCHAR2(3)

 

Indicates how the grant was made. Possible values:

  • YES if the privilege was granted commonly (CONTAINER=ALL was used)

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


See Also:

"DBA_SYS_PRIVS"