Re: audit all when role set

We are running 19.11 I have not started using Unified Auditing, maybe something to look into.

On Fri, Aug 13, 2021 at 7:40 AM Powell, Mark <mark.powell2_at_dxc.com> wrote:

> 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_at_freelists.org <oracle-l-bounce_at_freelists.org> on
> behalf of Jeff Chirco <backseatdba_at_gmail.com>
> *Sent:* Thursday, August 12, 2021 5:27 PM
> *To:* oracle-l-freelist <oracle-l_at_freelists.org>
> *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
>
>
>

--
http://www.freelists.org/webpage/oracle-l