Skip Headers
Oracle® Database Reference
12c Release 1 (12.1)

E17615-23
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
PDF · Mobi · ePub

DBA_USED_PUBPRIVS

DBA_USED_PUBPRIVS lists the privileges that are used from the PUBLIC role 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 who used the privilege from the PUBLIC role
SYS_PRIV VARCHAR2(40)   Used system privilege
OBJ_PRIV VARCHAR2(40)   Used object privilege
OBJECT_OWNER VARCHAR2(128)   Object owner
OBJECT_NAME VARCHAR2(128)   Name of the object that OBJ_PRIV is used to access
OBJECT_TYPE VARCHAR2(23)   Type of the object that OBJ_PRIV is used to access
OPTION$ NUMBER   Indicates whether the GRANT option or the ADMIN option was used:
  • 0 - Indicates that the GRANT option or ADMIN option was not used

  • 1 - Indicates that the GRANT option or ADMIN option was used


See Also: