SQL Language (MOSC)

MOSC Banner

Audit select , but not audit the queries launched by a certain user

edited May 15, 2015 6:33AM in SQL Language (MOSC) 3 commentsAnswered

Hello,

On Oracle 11.2.0.3

I need to audit all select operations on some tables in one schema.

But i should not audit the queries launched by a certain user,

(exclude from the audit the queries started by application to limit the size of the audit)

Is there any idea how can i achieve this ?

example  :

AUDIT SELECT ON IBPFA.ABGRE240 BY ACCESS WHENEVER SUCCESSFUL;

But I dont want to have audit entries for the selects run on IBPFA.ABGRE240 launched by IBPFA user.

Thanks

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