Database Security Products (MOSC)

MOSC Banner

sys user not audited with FGA

edited Oct 20, 2017 1:08PM in Database Security Products (MOSC) 1 commentAnswered ✓

Hi!

I have set up a number of Fine Grained Audits and they have been running for a while now and getting nearer production deployment I started check the trails more carefully. I then find that having a FGA for select on a few columns on a table doesn't generate a audit trail when SYS user is selecting from the table (select *). Other users do get a trail but not SYS and it is vital that we also get a trail for SYS selects on our tables.

Can't find any documentation about this except the audit_sys_operations parameter but in my eyes it looks ok.

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