如何从通过网站调用的存储过程获取网站用户的Windows登录名
我有一个网页在名为 WebUser 的帐户下运行（IIS 在该帐户下运行）
现在的问题是，当用户（内联网）访问该网页时，
用户通过 Windows 身份验证进行身份验证。
该网页调用存储过程SaveClientInfo。 当我尝试获取调用 SaveClientInfo 的用户名（例如 User1）时，
我通过 SYSTEM_USER
有没有办法从SaveClientInfo获取User1而无需传入用户名到存储过程？
这是存储过程定义的相关部分
create procedure SaveClientInfo
@ClientID int
... --; other parameters
as
begin
declare @UserName sysname
--; returns the name of user name that IIS runs under
--; But I would like to log the name of the person
--; who is accesing the site through Windows Authentication
select @UserName = SYSTEM_USER
--; Save client data and the person who saved the info
...
end
GO
I have a web page that runs under an account named, WebUser (IIS runs under this account)
Now the problem here is that, when the webpage is accessed by users (intranet),
users are authenticated through Windows Authentication.
The webpage calls a stored procedure, SaveClientInfo.
When I was trying to get the user's name (say, User1) who was calling SaveClientInfo,
I was getting WebUser instead of User1 through SYSTEM_USER
Is there a way to get User1 from SaveClientInfo without having to pass in the user name to the stored procedure?
Here is the relevant piece of sproc definition
create procedure SaveClientInfo
@ClientID int
... --; other parameters
as
begin
declare @UserName sysname
--; returns the name of user name that IIS runs under
--; But I would like to log the name of the person
--; who is accesing the site through Windows Authentication
select @UserName = SYSTEM_USER
--; Save client data and the person who saved the info
...
end
GO
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
除非您在 Web 应用程序中使用模拟，以便 Web 应用程序作为 Windows 身份验证用户进行连接，否则您不能。
Unless you use impersonation in your web app, so the web application connects as the Windows authenticated user, no you can't.
从 SQL 检索用户名应该只提供与连接关联的用户名 - 通常是 ASP.NET 使用的用户帐户。
在 .NET 端，您可以使用 (C#)
检索登录到您站点的用户的名称。我们用它来跟踪谁通过我们的管理站点对数据库进行了更改，等等。
Retrieving the name of the user from the SQL should just give you the username associated with the connection - typically, the user account used by ASP.NET.
On the .NET side, You can use (C#)
to retrieve the name of the user logged into your site. We use this to track who's making changes to the db through our admin site, among other thngs.