Database Administration (MOSC)

MOSC Banner

fga audit delete setting

edited Mar 16, 2018 5:02AM in Database Administration (MOSC) 1 commentAnswered

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!' );

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center