dotlike.net
 

NAVIGATION

PROJECTS

ITKB
 


MSSQL T-SQL: find users with where pass = username


here is a T-SQL job to list SQL-users where the password is the same as the username:

select name, type_desc, create_date; modify_date, default_database_name
from sys.sql_logins
where
PWDCOMPARE(name,password_hash) = 1
OR
PWDCOMPARE(LOWER(name),password_hash) = 1


    Article Details:

    FileID : 447
    Keywords : username, password, t-sql, mssql, username = password
    Authored by : davidr
    Views : 3965
    Submit Date : 2013-07-22 13:44:16

 
ETCETERA

Valid HTML 4.01 Transitional

http://twitter.com/dotlike