Tracking a Delete

[SSloss1]

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]

On Nov 2, 7:55 am, [e-mail] 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_WRKSTNAME, 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.