DBA_UNUSED_PRIVS v16
The DBA_UNUSED_PRIVS view provides information about all the unused privileges. The unused privileges are populated by the DBMS_PRIVILEGE_CAPTURE.GENERATE_RESULT procedure.
Superuser or the user with CAPTURE_ADMIN role can access this view.
| Name | Type | Description |
|---|---|---|
policy_name | NAME | Name of the privilege analysis policy. |
run_name | NAME | Name of the run for which privileges are analyzed. |
object_class | TEXT | Name of the database object like table, function, procedure, and so on.. |
object_name | TEXT | Name of the object for which unused privilege are recorded. |
column_name | TEXT | Name of the column for the unused object privilege. |
application | TEXT | Name of the application through which queries are run. For eg: psql. |
role_name | NAME | Name of the role whose privilege usage is analyzed and recorded. |
privilege_type | TEXT | Name of the unused privilege recorded during analysis. |