RE: Audit Table
From: Michelle (michelle.vanden_at_eglin.af.mil)
Date: 12/29/03
- Next message: Félix Meléndez: "How to cpy logins from one Server to another"
- Previous message: Eliyahu Goldin: "Re: Generating hash value"
- In reply to: Yuan Shao: "RE: Audit Table"
- Next in thread: Yuan Shao: "RE: Audit Table"
- Reply: Yuan Shao: "RE: Audit Table"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Mon, 29 Dec 2003 07:14:49 -0800
1). Both IIS and SQL Server if possible. It would be
better if we get the username from IIS and have it
delegated to SQL Server.
2). Basic Authentication w/SSL on IIS on one machine and
windows Authentication w/SSL on another.
>-----Original Message-----
>Hi Michelle,
>
>Thanks for your post. According to your description, I
understand that you
>want to record and return the current login username to
certain table in
>SQL Server, when you performed insert or update action.
If I have
>misunderstood, please feel free to let me know.
>
>Before we go any further, I would like to collect more
information from
>you: 1. Which username do you want to record, the
usernames used to log on
>IIS or SQL Server?
>2. Which authentication do you choose to log on IIS?
>
>So far as I know, if we want to record the usernames used
for SQL Server,
>we can try to use suser_sname() to return the string of
the current login
>identification name
>
>For more information regarding suser_sname function,
please refer to the
>following article on SQL Server Books Online.
>Topic: "SUSER_SNAME"
>
>On the SQL Server side, it seems hard to record the
usernames which are
>used to log on IIS.
>
>Thanks for using MSDN newsgroup.
>
>Regards,
>
>Michael Shao
>Microsoft Online Partner Support
>Get Secure! - www.microsoft.com/security
>This posting is provided "as is" with no warranties and
confers no rights.
>
>
>.
>
- Next message: Félix Meléndez: "How to cpy logins from one Server to another"
- Previous message: Eliyahu Goldin: "Re: Generating hash value"
- In reply to: Yuan Shao: "RE: Audit Table"
- Next in thread: Yuan Shao: "RE: Audit Table"
- Reply: Yuan Shao: "RE: Audit Table"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
