开发者

Are Authorized NT Users stored in a table in Microsoft SQL Server?

I am using Microsoft SQL Server 2008. While generating custom reports, I need to provide specific parameters based on the logged in user. That's why my app requires a table for users with 开发者_开发问答their ids, so that I can join whatever else I want with them. The problem starts when I inspect the results of querying Master..SysUsers. My NT user is not listed, however in the SysLogins table, my NT user account is listed there.


Microsoft said something here

They suggested that we rather use sys.database_principals, sys.sql_logins than SysUser, SysLogins.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜