7.89 DBA_UNUSED_SCHEMA_PRIVS

DBA_UNUSED_SCHEMA_PRIVS lists the schema 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)
SCH_PRIV	VARCHAR2(40)		Unused schema privilege
SCHEMA	VARCHAR2(128)		Schema on which the privilege was granted
ADMIN_OPTION	NUMBER		Indicates whether the privilege was granted with the ADMIN option: 0 - Indicates that the privilege was granted without the ADMIN option 1 - Indicates that the privilege was granted with the ADMIN option
RUN_NAME	VARCHAR2(128)		The name of the run during which the privilege was reported

Note:

This view is available starting with Oracle Database 23ai.

See Also:

• "DBA_UNUSED_SCHEMA_PRIVS_PATH" for privilege grant path information for unused schema privileges

• Oracle Database Security Guide for more information about privilege analysis

• Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_PRIVILEGE_CAPTURE.GENERATE_RESULT procedure