7.96 DBA_USED_OBJPRIVS
DBA_USED_OBJPRIVS
lists the object 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 |
---|---|---|---|
|
|
|
Name of the privilege analysis policy |
|
|
|
The sequence number of the privilege analysis run during which the privilege was reported |
|
|
|
Operating system login username |
|
|
|
Client host machine name |
|
|
|
Module name |
|
|
|
Name of the user whose privilege was reported |
|
|
|
Used role |
|
|
|
Used object privilege |
|
|
|
Object owner |
|
|
|
Name of the object that |
|
|
|
Type of the object that |
|
|
|
Name of the column that |
|
|
|
Indicates whether the
|
|
|
|
The name of the run during which the privilege was reported |
See Also:
-
"DBA_USED_OBJPRIVS_PATH" for privilege grant path information for used object 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