Oracle Fine-Grained Access (FGA) auditing excluding one source I want to audit DML statements coming from other places than application user &quot;tomcat&quot; (OS_USER attribute). I want to focus only on developers or support team changing data in any way.
DML Trigger doesn't log exact query which was executed, just query type (INSERT, UPDATE, DELETE).
With straightforward usage of FGA I cannot filter out application user &quot;tomcat&quot;. I am familiar with those questions:
Oracle auditing on specific user activity
Can this be accomplished with Oracles Fine Grained Auditing?
but information is logged in trace files, viewing which requires more effort, and I would like auditing to be accessed by dictionary view. Is it possible?
I helped my self with this:
BEGIN
    dbms_fga.add_policy(
      ... ,
      audit_condition =&gt; 'SYS_CONTEXT(''USERENV'',''OS_USER'') &lt;&gt; ''tomcat''',
      ...);
END;
/