Tracking a Delete

[SSloss1@gmail.com]

Hello all,

I'm trying to create a before trigger to track who initiated Delete
DML.
I know I can grab CURRENT USER, but because of the way we have
implemented our software I have to know the OS ID. I know I can grab
that using select from table(snapshot_ appl_info...) function, but
that's a global application list.

What I'm looking for is a way via SQL, inside a trigger, to determine
the current agent_id or appl_id within that connection of UOW.

Any ideas?

Thanks,

Scott

[deangc]

Re: Tracking a Delete

On Nov 2, 7:55 am, SSlo...@gmail.c om wrote:

Hello all,
>
I'm trying to create a before trigger to track who initiated Delete
DML.
I know I can grab CURRENT USER, but because of the way we have
implemented our software I have to know the OS ID. I know I can grab
that using select from table(snapshot_ appl_info...) function, but
that's a global application list.
>
What I'm looking for is a way via SQL, inside a trigger, to determine
the current agent_id or appl_id within that connection of UOW.
>
Any ideas?

One of the special registers is CURRENT CLIENT_APPLNAME , although when
I try that I get an empty string. There is also CURRENT
CLIENT_WRKSTNAM E, but likewise I get an empty string, possibly because
I am querying from the client? I'm not sure.

There is APPLICATION_ID( ) - but I don't know that this is useful
information from an audit point of view.