fga audit delete setting
Hi.
Oracle version - Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
single DB
There is a table with the fga audit delete setting.
begin
dbms_fga.add_policy(
object_schema => 'SYSTEM',
object_name => 'xx_test_001',
policy_name => 'AUDIT_xx_test_001',
statement_types => 'delete, update',
audit_trail => dbms_fga.db + dbms_fga.extended);
end;
/
Also, the table is restricted to delete and update using trigger.
CREATE OR REPLACE TRIGGER SYSTEM.TR_xx_test_001_AUDIT
after delete or update
on SYSTEM.xx_test_001
for each row
begin
RAISE_APPLICATION_ERROR( -20001, 'Query has attempted to delete/update audit data!' );