DBMS_FGA


To add audit policy
BEGIN
DBMS_FGA.add_policy(
object_schema => ‘MIS’,
object_name => ‘TRD_STATEMENTS_POS’,
policy_name => ‘POS_AUDIT’,
audit_condition => NULL, — Equivalent to TRUE
audit_column => ‘AGREEMENT_NO’,
statement_types => ‘SELECT,INSERT,UPDATE,DELETE’);
END;

To drop audit policy
BEGIN
DBMS_FGA.drop_policy(
object_schema => ‘MIS’,
object_name => ‘TRD_STATEMENTS_POS’,
policy_name => ‘POS_AUDIT’);
END;

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: