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

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

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


DBA_UNUSED_USERPRIVS lists the user privileges (without privilege grant paths) 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 a privilege analysis policy
USERNAME VARCHAR2(128)   Name of the user whose 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)
USER_PRIV VARCHAR2(18)   Unused user privilege
ONUSER VARCHAR2(128)   The user whose user privileges the grantee can exercise
GRANT_OPTION NUMBER   Indicates whether the privilege is granted with the GRANT option:
  • 0 - Indicates that the privilege is granted without the GRANT option

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

See Also: