Session Variables and Triggers

From: MichaelJA@xxxxxxxxx
Date: 26 Jun 2006 08:48:02 -0700

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?

.

Follow-Ups:
- Re: Session Variables and Triggers
  - From: Arnie Rowland
- Re: Session Variables and Triggers
  - From: Uri Dimant
- Re: Session Variables and Triggers
  - From: Mike C#

Prev by Date: Re: SQL 2005 - Searching Encrypted SSN
Next by Date: Audit Logging on Server Configuartion Changes
Previous by thread: Re: SQL 2005 - Searching Encrypted SSN
Next by thread: Re: Session Variables and Triggers
Index(es):
- Date
- Thread

Relevant Pages

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
... 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)