Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-sqlserver > #214
| Path | csiph.com!x330-a1.tempe.blueboxinc.net!usenet.pasdenom.info!aioe.org!eternal-september.org!feeder.eternal-september.org!.POSTED!not-for-mail |
|---|---|
| From | Erland Sommarskog <esquel@sommarskog.se> |
| Newsgroups | comp.databases.ms-sqlserver |
| Subject | Re: A Question on Triggers |
| Date | Mon, 25 Apr 2011 20:42:00 +0200 |
| Organization | Erland Sommarskog |
| Lines | 18 |
| Message-ID | <Xns9ED2D2927B3A8Yazorman@127.0.0.1> (permalink) |
| References | <77111122-3944-48ad-923b-dd0a3329d071@u38g2000prd.googlegroups.com> <2a56545e-0788-4534-ae23-b93430c877a6@t19g2000prd.googlegroups.com> |
| Mime-Version | 1.0 |
| Content-Type | text/plain; charset=windows-1252 |
| Content-Transfer-Encoding | 8bit |
| Injection-Info | mx02.eternal-september.org; posting-host="DD6dU+BfJNjsjSP4/K/V7w"; logging-data="28254"; mail-complaints-to="abuse@eternal-september.org"; posting-account="U2FsdGVkX1+b2FmiCQUt9G39CidpoPBL" |
| User-Agent | Xnews/2006.08.24 Mime-proxy/2.1.c.0 (Win32) |
| Cancel-Lock | sha1:po7NJThXirPukOQ+6jlefQPu8r8= |
| Xref | x330-a1.tempe.blueboxinc.net comp.databases.ms-sqlserver:214 |
Show key headers only | View raw
Fred. (ghrno-google@yahoo.com) writes: > 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@sommarskog.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
Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Find similar
A Question on Triggers Dom <dolivastro@gmail.com> - 2011-04-25 08:38 -0700
Re: A Question on Triggers "Fred." <ghrno-google@yahoo.com> - 2011-04-25 09:12 -0700
Re: A Question on Triggers Dom <dolivastro@gmail.com> - 2011-04-25 10:51 -0700
Re: A Question on Triggers Erland Sommarskog <esquel@sommarskog.se> - 2011-04-25 20:42 +0200
csiph-web