Re: find out who makes the update in a trigger event

From: Karen Abgarian <abvk_at_apple.com>
Date: Sat, 21 Jul 2001 21:29:35 GMT
Message-ID: <3B45308C.14C4AF1E@apple.com>

>
> > >
> > >
>
> And not only is v$session a view, not a table, you should never add any triggers
> to any object owned by SYS or SYSTEM. Look at the triggers suggested by Mario.
> Also, have you considered just using Oracle's built-in audit functionality?
>
> Daniel A. Morgan

Not only you should not, you cant add any triggers on v$ or SYS objects.

Audit logs everything but data.

In a trigger, you can select from v$session to find the session firing the change, using userenv('sessionid')/audsid, dbms_application_info or sys_context.

Regs
Karen Abgarian Received on Sat Jul 21 2001 - 16:29:35 CDT