Skip to Main Content
  • Questions

  • Here is one way to accomplish this goal

Breadcrumb

May 4th

Question and Answer

Thanks for the question.

Asked: December 16, 2019 - 2:37 pm UTC

Last updated: December 16, 2019 - 2:37 pm UTC

Version:

Viewed 1000+ times

You Asked

Hello,

I am currently working on unified auditing configuration for our 19c databases. It looks like there is the ability to apply audit policies by a wide variety of factors now. One thing I have not been able to find in the documentation that would be useful is the ability to audit via Account Profile. Is that possible in the current version?

Thanks
Josh Arnold

and we said...

This is not possible in the current release, and we don't have it on our roadmap right now. This should be fairly easy to accomplish by:

1) Use a login trigger to set an application context based on the user's password profile

2) Create a conditional unified audit policy that references that application context

If you really wanted to go the extra mile, you could have the login trigger set a secure application role instead, and base the unified audit policy on role membership, but that's probably more work than you need to do.


Is this answer out of date? If it is, please let us know via a Comment
more

Connor and Chris don't just spend all day on AskTOM. You can also catch regular content via Connor's blog and Chris's blog. Or if video is more your thing, check out Connor's latest video and Chris's latest video from their Youtube channels. And of course, keep up to date with AskTOM via the official twitter account.

More to Explore

PL/SQL demos

Check out more PL/SQL tutorials on our LiveSQL tool.

PL/SQL docs

PL/SQL reference manual from the Oracle documentation library