use zhongfei
create login a with password='password'
drop login securesql
create login securesql with password='NanWang19891209',check_expiration = on,check_policy = on
alter login securesql with password = 'NanWang123456'
alter login securesql disable
alter login securesql enable
select * from sys.server_role_members
execute sp_addsrvrolemember securesql,bulkadmin

create login test with password = 'NanWang19891209' ,check_expiration = on,check_policy = on
execute sp_addsrvrolemember test,sysadmin
create user test for login test
create user testsql for login test
use zhongfei
go
exec sp_change_users_login @action='report'
创建一个为peter的sql server登录名，然后创建一个可以访问中菲的数据库的数据库用户peter
create login peter with password ='NanWang19891209'
go
use zhongfei
go
create user peter from login peter
drop login xiaolu
drop user xiaolu
create login xiaolu with password ='NanWang19891209'
go
use zhongfei
go
create user xiaolu from login xiaolu
grant select to xiaolu
grant alter to xiaolu
use zhongfei
select * from  t_employee