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)

INHERITED

VARCHAR2(3)

Indicates whether the grant was inherited from another container (YES) or not (NO)

This column is available starting with Oracle Database 12c Release 2 (12.2.0.1).