摘要:
use[Three_Kingdom]exec sp_addrole'role1'创建角色role1grantupdate,selete,delete onsanguo,sanguo2 to role1将表sanguo的所有权限授予role1grant select on sanguo_2 to role1 将表sanguo_2的select权限授予 role1exec sp_addlogin 'login1','pass','Three_Kingdom' 添加登录login1,密码pass,默认数据库Three_Kingdomex 阅读全文