The Library is currently in the process of being upgraded from Oracle Database Version 18.104.22.168 to 22.214.171.124.
Demos are being upgraded to reflect the new Container paradigm as well as EBR (Edition Based Redefinition) and may contain references to CDBs, PDBs,
and other objects you may not be familiar with such as CDB_OBJECTS_AE: Welcome to 12c.
Do you remember when mainframes were replaced by client-server? When
client-server was replaced by n-tier architecture? The "Cloud" is a
distraction ... DevOps is not. Prepare for the future.
Provides an API for database privilege analysis. Requires Oracle Enterprise Edition and the Data Vault license.
For usage see CREATE_CAPTURE below
SQL> desc sys.role_name_list
sys.role_name_list VARRAY(10) OF VARCHAR2(128)
Input condition does not match the given privilege capture type.
invalid input value or length for parameter 'condition'
Owned by SYS with EXECUTE granted to the CAPTURE_ADMIN role. The CAPTURE_ADMIN role is also granted to the DBA role.
Creates a privilege analysis policy to show privilege use by database users. It also optionally specifies the roles for which privilege use is to be analyzed, and the conditions under which privilege use will be analyzed
name IN VARCHAR2,
description IN VARCHAR2 DEFAULT NULL,
type IN NUMBER DEFAULT G_DATABASE,
roles IN role_name_list DEFAULT role_name_list(),
condition IN VARCHAR2 DEFAULT NULL);
Captures all privilege use, except privileges used by SYS
Captures privilege use for the specified roles
Captures privilege use when the condition parameter evaluates to TRUE
Captures privilege use for the specified roles when the condition parameter evaluates to TRUE