am facing some problems,
am having a db server and 10 client machine.
without my knowledge somebody firing some database query from client machine.
is ther any way to get who fired that qury at wht time and which query?
DBMS_FGA.ADD_POLICY(object_schema => 'schema_name',
object_name => 'table_name',
policy_name => 'AUDIT_123',
audit_condition => 'SYS_CONTEXT (''USERENV'',''IP_ADDRESS'')!= ''10.0.0.0''', -- here you can set which ip you want to audit or which you dont want audit
…enable => TRUE);
your audit information are on table dba_fga_audit_trail.
note: information may take to much information and space on disk. because FGA audit all transactions on your system.