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

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

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


DBA_PRIV_CAPTURES lists the privilege analysis policies in the database.

Column Datatype NULL Description
NAME VARCHAR2(128) NOT NULL Name of the privilege analysis policy
DESCRIPTION VARCHAR2(1024)   Description of the privilege analysis
TYPE VARCHAR2(16)   Type of the privilege analysis policy.

Possible values:

  • G_DATABASE: Database wide privilege analysis

  • G_ROLE: Role privilege analysis

  • G_CONTEXT: Context privilege analysis

  • G_ROLE_AND_CONTEXT: Role and context privilege analysis

ENABLED VARCHAR2(1)   Enabling status of the privilege analysis
ROLES ROLE_ID_LIST   List of roles whose privileges to analyze if the privilege analysis type is G_ROLE or G_ROLE_AND_CONTEXT
CONTEXT VARCHAR2(4000)   Context condition if the privilege analysis type is G_CONTEXT or G_ROLE_AND_CONTEXT

See Also:

Oracle Database Vault Administrator's Guide for more information about privilege analysis