--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 creating 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