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

User identity

P: n/a
Hi,

Is it possible to capture the identity of the user in, for example, a
trigger? What I would like to do is identify, at the server, who is
making changes to a given table.

Thanks!

Alejandrina

Mar 2 '07 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Sure,

use the USER special register.

.....insert into audit_table (user_id) values (user)

/T

On Mar 2, 3:15 pm, "apattin" <apat...@gmail.comwrote:
Hi,

Is it possible to capture the identity of the user in, for example, a
trigger? What I would like to do is identify, at the server, who is
making changes to a given table.

Thanks!

Alejandrina

Mar 2 '07 #2

P: n/a
THANKS! I'll give this a try.

Alejandrina

On Mar 2, 6:44 pm, "Tomas" <thal...@gmail.comwrote:
Sure,

use the USER special register.

....insert into audit_table (user_id) values (user)

/T

On Mar 2, 3:15 pm, "apattin" <apat...@gmail.comwrote:
Hi,
Is it possible to capture the identity of the user in, for example, a
trigger? What I would like to do is identify, at the server, who is
making changes to a given table.
Thanks!
Alejandrina

Mar 3 '07 #3

P: n/a
On Mar 2, 8:15 pm, "apattin" <apat...@gmail.comwrote:
Hi,

Is it possible to capture the identity of the user in, for example, a
trigger? What I would like to do is identify, at the server, who is
making changes to a given table.

Thanks!

Alejandrina
Besides the USER special register, you can use SQLID special register
available in DB2 for z/OS

Mar 6 '07 #4

This discussion thread is closed

Replies have been disabled for this discussion.