Capturing the user's identity in a web application

Jane

In the SQL Server backend of an intranet web application I want to capture
the user's identity for an audit trail in the Insert and Update triggers.
However the users are coming into the application as a generic WebUser. Is
there any way to capture their name for the audit trail? (I'm more a SS
person than a web developer).

Uri Dimant

Jane
SELECT HOST_NAME() ??

"Jane" <Jane@discussions.microsoft.com> wrote in message
news:5D815517-BB02-4CCB-BA80-E873D37148CB@microsoft.com...
> In the SQL Server backend of an intranet web application I want to capture
> the user's identity for an audit trail in the Insert and Update triggers.
> However the users are coming into the application as a generic WebUser.
> Is
> there any way to capture their name for the audit trail? (I'm more a SS
> person than a web developer).

Steve Troxell

Jane wrote:
> In the SQL Server backend of an intranet web application I want to capture
> the user's identity for an audit trail in the Insert and Update triggers.
> However the users are coming into the application as a generic WebUser. Is
> there any way to capture their name for the audit trail? (I'm more a SS
> person than a web developer).

Your web application can use SET CONTEXT_INFO to set the username on the
connection. The triggers can then read this and pull the username out.
Lookup SET CONTEXT_INFO in Books Online.

Steve Troxell