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.