Database Security Products (MOSC)

MOSC Banner

Trying to understand auditing roles

edited Jun 21, 2018 10:18AM in Database Security Products (MOSC) 3 commentsAnswered ✓

Oracle = 12.1.0.2.180417, Linux.

I am setting up an audit policy to audit everything that happens when someone is connected using that role.

The audit policy is defined as:

CREATE AUDIT POLICY dbawtf ROLES mydbas;

The audit policy correctly audits users in the "mydbas" role, but also audit every other user even if they are not assigned the "mydbas" role.

My understanding is that only the users using the "mydbas" role would be audited. 

So I am sure I am misunderstanding how role based auditing is supposed to work.  Can somebody point me to a clear example of auditing for a role?

Tagged:

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