6.92 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

RUN_NAMEFoot 1

VARCHAR2(128)

The name of the run during which the privilege was reported

Footnote 1

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

See Also: