DBA_USED_SCHEMA_PRIVS_PATH

DBA_USED_SCHEMA_PRIVS_PATH lists the schema privileges 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 reported
`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
`SCH_PRIV`	`VARCHAR2(40)`		Used schema privilege
`SCHEMA`	`VARCHAR2(128)`		Schema on which the privilege was granted
`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
`PATH`	`GRANT_PATH`		Schema privilege grant paths
`RUN_NAME`	`VARCHAR2(128)`		The name of the run during which the privilege was reported

Note: This view is available starting with Oracle AI Database 26ai.

See Also:

“DBA_UNUSED_SCHEMA_PRIVS_PATH”
“DBA_USED_SCHEMA_PRIVS”
Oracle AI Database Security Guide for more information about privilege analysis
Oracle AI Database PL/SQL Packages and Types Reference for more information about the DBMS_PRIVILEGE_CAPTURE.GENERATE_RESULT procedure