|
|
Oracle Database 12.1.0.2
RHEL 7.4
Hello Erman,
I would like to enable fine grained audit policy for all tables in a schema called cbs.
BEGIN
DBMS_FGA.ADD_POLICY(
OBJECT_SCHEMA => 'cbs',
OBJECT_NAME => '*',
POLICY_NAME => 'DUP_ACCESS2',
statement_types => 'DELETE');
END;
/
When I delete a record in a table, I do not see log being generated.
SQL> SELECT policy_name, object_name, statement_type, os_user, db_user FROM dba_fga_audit_trail;
no rows selected
Kindly advise
Regards,
Roshan
SQL> SELECT policy_name, object_name, statement_type, os_user, db_user FROM dba_fga_audit_trail;
no rows selected
|
Locked
