Re: Session Variables and Triggers

system_user returns the current network login. Try

SELECT system_user

So, unless all users use the same network logins -this will give you what
you want.

--
Arnie Rowland, YACE*
"To be successful, your heart must accompany your knowledge."

*Yet Another Certification Exam


<MichaelJA@xxxxxxxxx> wrote in message
news:1151336882.355654.55530@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I'm currently trying to create an auditing system for an existing
system. I would like to create triggers that will automatically track
changes within certain tables in my database but I wish to include the
user id of who is making the changes. Unfortunatly all users are using
the same db login information andseveral users may be accessing the db
at the same time, making SQL system variables useless. I thought about
making a table with session/user id variables, and using it to keep
track of the users, but i still have no way of specifying in a trigger
which users a transaction belongs to. Any suggestions?



.

Relevant Pages

  • Session Variables and Triggers
    ... I'm currently trying to create an auditing system for an existing ... I would like to create triggers that will automatically track ... making SQL system variables useless. ...
    (microsoft.public.sqlserver.security)
  • Re: Session Variables and Triggers
    ... I would like to create triggers that will automatically track ... making SQL system variables useless. ... which users a transaction belongs to. ...
    (microsoft.public.sqlserver.security)
  • Re: Session Variables and Triggers
    ... How about grabbing the net_address of the current spid: ... I would like to create triggers that will automatically track ... making SQL system variables useless. ...
    (microsoft.public.sqlserver.security)