开发者

Where are SQL Server user credentials stored?

Where are SQL Server us开发者_JAVA百科er name and password stored?


In the DB called "master", you can view them with:

SELECT * FROM master.sys.syslogins

However passwords are encrypted.

As per Richard's comment: please note that syslogins is no longer a physical table (in SQL server 2005 and 2008) but only a view provided for backwards compatibility.

0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜