在数据库中给windows组授权连接数据库
create login [sql1\teacher] from windows with deafault_database=data1
启用Guest:
GRANT Connect TO Guest
禁用Guest:
1 deny Connect TO Guest
2 REVOKE Connect FROM Guest
数据库的安全
原文:http://bks2015.blog.51cto.com/9847303/1623158