What full version of Oracle? If 12.1 or higher can Unified Auditing be used?
We use a privileged username which developers can obtain the password to via a
request and we audit all DML performed by the username. The password is
changed by a routine after usage.
Mark Powell
Database Administration
(313) 592-5148
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx <oracle-l-bounce@xxxxxxxxxxxxx> on behalf
of Jeff Chirco <backseatdba@xxxxxxxxx>
Sent: Thursday, August 12, 2021 5:27 PM
To: oracle-l-freelist <oracle-l@xxxxxxxxxxxxx>
Subject: audit all when role set
We have a password protected role that has some escalated privileges to tables
that some developers can use when in need. Is there any way I can enable
auditing of all activities when this role is set? This way we can report on
what was being done.
Thanks,
Jeff