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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center