Re: Session Variables and Triggers

From: "Uri Dimant" <urid@xxxxxxxxxxx>
Date: Wed, 28 Jun 2006 09:41:15 +0300

Michael
What is the version are you using?

<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?

References:
- Session Variables and Triggers
  - From: MichaelJA

Prev by Date: Re: SQL 2005 - Searching Encrypted SSN
Next by Date: Re: SQL 2005 - Searching Encrypted SSN
Previous by thread: Re: Session Variables and Triggers
Next by thread: Re: Session Variables and Triggers
Index(es):
- Date
- Thread

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
... system_user returns the current network login. ... I would like to create triggers that will automatically track ... making SQL system variables useless. ...
(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)