开发者

Where are SQL Server user credentials stored?

开发者 https://www.devze.com 2023-02-14 06:18 出处:网络
Where are SQL Server us开发者_JAVA百科er name and password stored? In the DB called \"master\", you can view them with:

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

精彩评论

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