Re: Obtaining Window login name from a trigger
From: Herb (Herb_at_discussions.microsoft.com)
Date: 07/09/04
- Next message: Herb: "RE: Obtaining Window login name from a trigger"
- Previous message: Khatri: "Re: Query using dynamic column names"
- Maybe in reply to: Herb: "Obtaining Window login name from a trigger"
- Messages sorted by: [ date ] [ thread ]
Date: Fri, 9 Jul 2004 04:39:02 -0700
Thanks for the suggestion. I will give that a try.
"Jasper Smith" wrote:
> You'll need to pass the "real" login name through to SQL. One technique for
> this when an application uses a single service account is to use SET
> CONTEXT_INFO to pass the information through with the user connection and
> pull this out in your trigger (i. Note that you have to explicitly set this
> in your app for each connection that you require this information for. In
> some configurations this may not be practical/possible. See BOL for more on
> the command.
>
> --
> HTH
>
> Jasper Smith (SQL Server MVP)
> http://www.sqldbatips.com
> I support PASS - the definitive, global
> community for SQL Server professionals -
> http://www.sqlpass.org
>
> "Herb" <Herb@discussions.microsoft.com> wrote in message
> news:38AB6DF7-C403-469B-A00C-F56CAE4DB2DD@microsoft.com...
> > Hi,
> >
> > We are running SQL 2K with SQL Server and Windows authentication. Our
> system has been designed to login external user to SQL Server using one
> login account. I am trying to retrieve that actual Windows login user name
> from a trigger. Does anyone know how I accomphish this task.
>
>
>
- Next message: Herb: "RE: Obtaining Window login name from a trigger"
- Previous message: Khatri: "Re: Query using dynamic column names"
- Maybe in reply to: Herb: "Obtaining Window login name from a trigger"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
