//创建登陆名和密码
EXEC SP_ADDLOGIN 'anlantan','123'
go
//创建用户访问表的权限
EXEC SP_GRANTDBACCESS 'anlantan','worker'
go
//创建角色和添加权限
--C 是表明
EXEC SP_ADDROLE 'WOR'
EXEC SP_ADDROLEMEMBER 'WOR','worker'
GRANT UPDATE ON C TO WOR
GRANT SELECT ON C TO WORKER
go
//创建登陆名和密码
EXEC SP_ADDLOGIN 'anlantan','123'
go
//创建用户访问表的权限
EXEC SP_GRANTDBACCESS 'anlantan','worker'
go
//创建角色和添加权限
--C 是表明
EXEC SP_ADDROLE 'WOR'
EXEC SP_ADDROLEMEMBER 'WOR','worker'
GRANT UPDATE ON C TO WOR
GRANT SELECT ON C TO WORKER
go
转载于:https://www.cnblogs.com/anlantan/archive/2010/01/10/1643549.html