–Creating a Login which has same password as its login name. Then creating a user with same name –and assigned it db_owner access. CREATE LOGIN mssqltips WITH PASSWORD = ‘mssqltips’ , CHECK_POLICY = OFF go use tempdb go CREATE USER mssql
–Creating a Login which has same password as its login name. Then cr本文来源gao@!dai!ma.com搞$$代^@码!网!eating a user with same name
–and assigned it db_owner access.
CREATE LOGINmssqltipsWITH PASSWORD=‘mssqltips’
, CHECK_POLICY=OFF
go
use tempdb
go
CREATE USER mssqltips forloginmssqltips
go
sp_addrolemember‘db_owner’,mssqltips
go
–Creating a Login without password. Then creating a user with same name and assigned it db_owner access.
CREATE LOGINmssqltips_1WITH PASSWORD=”
, CHECK_POLICY=OFF
go
use tempdb
go
CREATE USER mssqltips_1 for login mssqltips_1
go
sp_addrolemember‘db_owner’,mssqltips_1
go
转载请注明原文链接：数据库管理安全管理识别SQLServer中空密码或者弱密码的
