Are you using VPD in that database?
On Tue, Nov 5, 2019 at 12:36 AM Charlotte Hammond <
dmarc-noreply@xxxxxxxxxxxxx> wrote:
Hello All,
In my database audit trail I can see lots of entries for use of the
privilege "EXEMPT ACCESS POLICY" (PRIV_USED) for a particular database user
(a shared account used by the front end application - sessions are
created/destroyed dynamically through the day). The RETURNCODE is 0 for
these entries.
However this database user does not have this privilege granted to them
either directly or through a role (and the 1 role they have does not have
any system privileges). Also, if I log in directly as this database user
using sqlplus I do not have this privilege. I presume the application is
doing something special when it creates the session but I cannot think what!
So where is this privilege coming from to appear in the audit trail? Any
suggestions on how to track this down much appreciated!
Thanks,
Charlotte