Database Security Products (MOSC)

MOSC Banner

FGA - audit content of WHERE clause

edited Jun 22, 2024 12:26AM in Database Security Products (MOSC) 3 commentsAnswered

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

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center