Which has the higher priority in your organization: Deploying a new database or securing the ones you already have?
Looking for a website, and resources, dedicated solely to securing Oracle databases? Check out DBSecWorx.
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