sql登入賬號密碼比對

weixin_30770495發表於2016-07-23
原文網址 : https://blog.csdn.net/weixin_30770495/article/details/95111733
SQL密碼

 
  
--find SQL login with blank passwords
select name,type_desc,create_date from sys.sql_logins where pwdcompare('', password_hash) = 1

--find SQL login with password same as name
select name,type_desc,create_date from sys.sql_logins where pwdcompare(name, password_hash) = 1

--比對sa的密碼是否為123abc
SELECT TOP 50 *
FROM sys.sql_logins sl
WHERE name = 'sa' AND pwdcompare('123abc', password_hash) = 1

轉載於:https://www.cnblogs.com/heqianjin/p/5698640.html

相關文章