Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Unified audit trail: logon /logoff policy for all users except one

oraLaroJan 2 2024 — edited Jan 2 2024

oracle 19.20

We have an audit policy for all logons and logoffs.

 create audit policy connection_policy actions logon, logoff;
 audit policy connection_policy;

Simple, tried and trusted, works and audits all logon/logoffs.

We recently started with a new monitoring tool that enters and exits every time its scrapes data (>500k entries a day and growing as we use the tool more) and is now accounting for 80% of our audit trail with logon/logoffs. We're happy enough not to audit logon/logoff for this user, so is there a way to exclude a specific user from a general logon/off policy above?

And yes, working with vendor to try and get the tool to use a persistent connection for the reporting tool, but thats an aside as we may have other use cases for (AUDIT everything_for_all_users EXCEPT FOR (list of usernames)) if there was a way to do that.

This post has been answered by sicun on Jan 2 2024
Jump to Answer
Comments
Post Details
Added on Jan 2 2024
2 comments
1,198 views