DBA_XS_PRIVILEGE_GRANTS

The DBA_XS_PRIVILEGE_GRANTS data dictionary view lists all the Real Application Security system or schema level privilege grants defined in the database.

Column Datatype NULL Description
PRIVILEGE VARCHAR2(128)   Name of the application privilege
GRANTEE VARCHAR2(128)   Name of the user to whom access was granted
GRANTEE_TYPE VARCHAR2(5)   Type of the grantee: Database or Real Application Security user or role
SCHEMA VARCHAR2(128)   Schema of the privilege