ACE Director Alum Daniel Morgan, founder of Morgan's Library, is scheduling
complimentary technical Workshops on Database Security for the first 30
Oracle Database customers located anywhere in North America, EMEA, LATAM, or
APAC that send an email to
firstname.lastname@example.org. Request a Workshop for
your organization today.
This package configures auditing for labels and policies specific to Oracle Label Security and, in addition, creates an auditing-related view.
Owned by LBACSYS with no privileges granted.
To use this package a schema must be granted the policy_DBA role.
Enables policy-specific auditing. Audit records capture Oracle OLS administrative actions and the use of Oracle Label Security privileges
that were used during logons, DML executions, and trusted stored procedure invocations
policy_name IN VARCHAR2,
users IN VARCHAR2 DEFAULT NULL,
audit_option IN VARCHAR2 DEFAULT NULL,
audit_type IN VARCHAR2 DEFAULT NULL, -- options 'BY ACCESS' or 'BY SESSION'
success IN VARCHAR2 DEFAULT NULL); -- options 'SUCCESSFUL' or 'NOT SUCCESSFUL'
Audits application of specified Oracle Label Security policies to tables and schemas
Audits use of all policy-specific privileges
Audits removal of specified Oracle Label Security policies from tables and schemas
Audits the setting of user authorizations, and user and program privileges