The Library is currently in the process of being upgraded from Oracle Database Version 188.8.131.52 to 184.108.40.206.
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.
Also important ... there are rumors on the web about SPARC and Solaris being discontinued. Welcome to the age of fake news.
There is absolutely not a byte of truth to these irresponsible rumors.
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