Home » RDBMS Server » Security » Fine Grained Auditing only for insert on table made by a specific user
Fine Grained Auditing only for insert on table made by a specific user [message #613903] Tue, 13 May 2014 08:15 Go to next message
Malakay79
Messages: 41
Registered: September 2007
Member
I need to enable a fga policy in order to audit insert statement for userA, only when this user executes an insert in a specific tableof another user.
I used this:
      dbms_fga.add_policy(
      object_schema   => 'USERB',
      object_name     => 'TABLE',
      policy_name     => 'AUDIT_TB',
      statement_types => 'INSERT',
      handler_schema  => 'USERA',
      audit_trail =>      DBMS_FGA.XML + DBMS_FGA.EXTENDED,
      enable          => true);


But with this policy I audit all insert made by all users on this table.

Is there a way to filter audit only for userA.

I can't use standard audit.
Re: Fine Grained Auditing only for insert on table made by a specific user [message #613907 is a reply to message #613903] Tue, 13 May 2014 08:24 Go to previous message
Michel Cadot
Messages: 66437
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
handler_schema is not the schema on which the policy applies but the schema that will own the handler.
Try:
audit_condition => 'USER=''USERA'''


[Edit: use code tags to differentiate '' and "]

[Updated on: Tue, 13 May 2014 08:24]

Report message to a moderator

Previous Topic: Audit oracle and legal value
Next Topic: User taking more time to reset password
Goto Forum:
  


Current Time: Mon Jun 17 18:05:51 CDT 2019