A Question on Triggers

#1

I'm just reading through the help sites for information about creating
a Trigger. I'm using it to debug a program. The trigger will record
the exact time a record is updated in a certain table. My question
is: Is there any way to capture the user that is doing the updating?
For example is there something like a GET_USER_ID() function that I
can record in the trigger?

Thanks, Dom

#2

On Apr 25, 11:38*am, Dom <dolivas... (AT) gmail (DOT) com> wrote:

Quote:

I'm just reading through the help sites for information about creating
a Trigger. *I'm using it to debug a program. *The trigger will record
the exact time a record is updated in a certain table. *My question
is: *Is there any way to capture the user that is doing the updating?
For example is there something like a GET_USER_ID() function that I
can record in the trigger?

Thanks, Dom

SYSTEM_USER is documented in as returning the login name of the
current user. What it seem to return in my environment is the login
ID of the current user, in the form [domain]\[userid] where [domain]
is the short or local domain name.

Fred.

#3

On Apr 25, 12:12*pm, "Fred." <ghrno-goo... (AT) yahoo (DOT) com> wrote:

Quote:

On Apr 25, 11:38*am, Dom <dolivas... (AT) gmail (DOT) com> wrote:

I'm just reading through the help sites for information about creating
a Trigger. *I'm using it to debug a program. *The trigger will record
the exact time a record is updated in a certain table. *My question
is: *Is there any way to capture the user that is doing the updating?
For example is there something like a GET_USER_ID() function that I
can record in the trigger?

Thanks, Dom

SYSTEM_USER is documented in as returning the login name of the
current user. *What it seem to return in my environment is the login
ID of the current user, in the form [domain]\[userid] where [domain]
is the short or local domain name.

Fred.

Thanks, Fred. Exactly what I wanted.

Dom

#4

Fred. (ghrno-google (AT) yahoo (DOT) com) writes:

Quote:

SYSTEM_USER is documented in as returning the login name of the
current user. What it seem to return in my environment is the login
ID of the current user, in the form [domain]\[userid] where [domain]
is the short or local domain name.

Small caveat here: it is better in most cases to use original_login().

In most cases, they will show the same thing, but if there has been
impersonation, original_login() will show you the user who actually
logged into SQL Server.
--
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

A Question on Triggers

comp.databases.ms-sqlserver comp.databases.ms-sqlserver

A Question on Triggers - 04-25-2011 , 10:38 AM

Re: A Question on Triggers - 04-25-2011 , 11:12 AM

Re: A Question on Triggers - 04-25-2011 , 12:51 PM

Re: A Question on Triggers - 04-25-2011 , 01:42 PM