USE [master]
--创建登录账号
CREATE login username with password='dba'
--创建登录用户
USE userdb
CREATE USER leon FOR LOGIN username WITH DEFAULT_SCHEMA=userdb
GO
--创建角色
CREATE ROLE [db_ROLE] AUTHORIZATION [leon]
--创建角色权限
GRANT CONTROL ON dbo.Customer TO [db_ROLE] WITH GRANT OPTION
GRANT SELECT ON [dbo].[TABLEName] TO [db_ROLE] WITH GRANT OPTION
DENY DELETE ON [dbo].[TABLEName] TO [db_ROLE]
DENY UPDATE ON [dbo].[TABLEName] TO [db_ROLE]
--添加角色到登录用户
EXEC sp_addrolemember N'db_ROLE', N'leon'
--创建登录账号
CREATE login username with password='dba'
--创建登录用户
USE userdb
CREATE USER leon FOR LOGIN username WITH DEFAULT_SCHEMA=userdb
GO
--创建角色
CREATE ROLE [db_ROLE] AUTHORIZATION [leon]
--创建角色权限
GRANT CONTROL ON dbo.Customer TO [db_ROLE] WITH GRANT OPTION
GRANT SELECT ON [dbo].[TABLEName] TO [db_ROLE] WITH GRANT OPTION
DENY DELETE ON [dbo].[TABLEName] TO [db_ROLE]
DENY UPDATE ON [dbo].[TABLEName] TO [db_ROLE]
--添加角色到登录用户
EXEC sp_addrolemember N'db_ROLE', N'leon'