By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,334 Members | 1,266 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,334 IT Pros & Developers. It's quick & easy.

Tracking a Delete

P: n/a
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

Nov 2 '07 #1
Share this Question
Share on Google+
1 Reply


P: n/a
On Nov 2, 7:55 am, SSlo...@gmail.com 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.

Nov 3 '07 #2

This discussion thread is closed

Replies have been disabled for this discussion.