6.102 DBA_USED_SYSPRIVS

DBA_USED_SYSPRIVS lists the system privileges (without privilege grant paths) that are 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

SEQUENCE

NUMBER

NOT NULL

The sequence number of the privilege analysis run during which the privilege was used

OS_USER

VARCHAR2(128)

Operating system login username

USERHOST

VARCHAR2(128)

Client host machine name

MODULE

VARCHAR2(64)

Module name

USERNAME

VARCHAR2(128)

NOT NULL

Name of the user whose privilege was reported

USED_ROLE

VARCHAR2(128)

Used role

SYS_PRIV

VARCHAR2(40)

Used system privilege

ADMIN_OPTION

NUMBER

Indicates whether the ADMIN option was used:

  • 0 - Indicates that the ADMIN option was not used

  • 1 - Indicates that the ADMIN option was used

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: