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

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

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

DBA_UNUSED_PRIVS

DBA_UNUSED_PRIVS lists the privileges that are not used for the privilege analysis policies reported by the DBMS_PRIVILEGE_CAPTURE.GENERATE_RESULT procedure.

This view provides access to analyzed privilege records in SYS tables.

You must have the CAPTURE_ADMIN role to access this view.

Column Datatype NULL Description
CAPTURE VARCHAR2(128) NOT NULL Name of the privilege analysis policy
USERNAME VARCHAR2(128)   Name of the user whose unused privileges are reported
ROLENAME VARCHAR2(128)   Name of the role whose unused privileges are reported (for ROLE type privilege analysis or ROLE AND CONTEXT privilege analysis)
SYS_PRIV VARCHAR2(40)   Unused system privilege
OBJ_PRIV VARCHAR2(40)   Unused object privilege
USER_PRIV VARCHAR2(18)   Unused user privilege
OBJECT_OWNER VARCHAR2(128)   Object owner
OBJECT_NAME VARCHAR2(128)   Name of the object that USERNAME has OBJ_PRIV or USER_PRIV on
OBJECT_TYPE VARCHAR2(23)   Type of the object that OBJ_PRIV has accessed or USER if USER_PRIV was used
COLUMN_NAME VARCHAR2(128)   Name of the column that OBJ_PRIV has access on
OPTION$ NUMBER   Indicates whether the privilege is granted with the GRANT option or the ADMIN option:
  • 0 - Indicates that the privilege is granted without the GRANT option or ADMIN option

  • 1 - Indicates that the privilege is granted with the GRANT option or ADMIN option

PATH GRANT_PATH   Privilege grant paths

See Also: