6.86 DBA_UNUSED_USERPRIVS

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

RUN_NAME

VARCHAR2(128)

The name of the run during which the privilege was reported

See Also: