FGA - audit content of WHERE clause
Hi,
oracle database 19c
using FGA, I need to audit all sql on a table where a column is (or is NOT) referenced in the WHERE clause.
create table t1 (c1 number(10) , c2 number(10) , c3 number(10) );
SELECT * FROM t1 WHERE c3=xxx; —> audit this
SELECT * FROM t1 WHERE c3 in (x, y, z); —> audit this
SELECT * FROM t1 WHERE c2=xxx; —> no audit this
Is this doable in FGA?
Thanks
Shahram