Re: Identify users logged thru browser

From: Celina Coe (ccoe@lsuhsc.edu)
Date: 01/24/03 

From: "Celina Coe" <ccoe@lsuhsc.edu>
Date: Fri, 24 Jan 2003 08:36:59 -0800

Did you discover a way to do this? I still have not gotten
a way? I am having the same problem as described below.

I have been assigned to set up auditing on specific tables
in our application and generate a report of the audit
items. I am a developer and not a DBA....

I have set up the triggers on each table successfully.
However, I am not getting the actual logged in User ID
that caused the trigger to fire. I am getting the generic
id (SA) used to actually access the database. This is
not useful in identifying who actually made the changes
for reporting purposes.

   Question: Has anyone been able to find a way to get
the actual logged on user id using Triggers at the
database level in SQL Server 2000??????

Please help. Thanks,
 

>-----Original Message-----
>>From SQL's point of view they are all the same user/host
>because all it's connections are from the web server.
>If you manage session state using a SQL table then you can
>capture HTTP header information etc at the application
level
>(ASP) and pass that into some session start procedure but
>as far as sql server is concerned they are all the same.
>
>--
>HTH
>
>Jasper Smith (SQL Server MVP)
>
>I support PASS - the definitive, global
>community for SQL Server professionals -
>http://www.sqlpass.org
>
>"sridhar_t@hotmail.com" <thotakura@comcast.net> wrote in
message
>news:075b01c2c1d2$49b31040$d2f82ecf@TK2MSFTNGXA09...
>> Hi,
>>
>> I want to identify all the user's individually that
>> logged on to database server from web application.
>>
>> All the user's are connecting using the same UserName
>> and Password. When i looked in the sysprocesses table, I
>> am able to identify the users logged thru Query Analyzer
>> but not able to identify the users logged thru web
>> application. All the users have the same host,username ,
>> net_address,....
>>
>> Any help will be appreciated.
>>
>> Thanks
>> Sridhar
>
>
>.
>

Relevant Pages

  • Re: MS Access DAO -> ADO.NET Migration
    ... William Vaughn ... Microsoft MVP ... Hitchhiker's Guide to Visual Studio and SQL Server ... My migration app works building a SSCE database file with imported data ...
    (microsoft.public.dotnet.framework.adonet)
  • Re: Cluster will not fail over.
    ... > As far as the TCP/IP issue goes, you had to rebuild the cluster and were ... > able to restore the master database. ... > a cluster installation you'll have to revisit. ... >> This worked bringing up the sql server in minimal mode. ...
    (microsoft.public.sqlserver.clustering)
  • Re: Configuring SQLServer Session State Storage on .NET 1.0 and 1.1
    ... The ASP.NET applications are configured to store session ... state in SQL Server, all of which are using the same SQL Server machine. ... > The SQL Server database was originally created using the the ... and will require a session state database. ...
    (microsoft.public.dotnet.framework.setup)
  • Re: Configuring SQLServer Session State Storage on .NET 1.0 and 1.1
    ... The ASP.NET applications are configured to store session ... state in SQL Server, all of which are using the same SQL Server machine. ... > The SQL Server database was originally created using the the ... and will require a session state database. ...
    (microsoft.public.dotnet.framework)
  • Re: Configuring SQLServer Session State Storage on .NET 1.0 and 1.1
    ... The ASP.NET applications are configured to store session ... state in SQL Server, all of which are using the same SQL Server machine. ... > The SQL Server database was originally created using the the ... and will require a session state database. ...
    (microsoft.public.dotnet.framework.aspnet)