--Create a login account for the 'test' user execute sp_addlogin 'test','1234','Northwind',null go --Create a group execute sp_addgroup 'testgroup' go --Add the test user to Database execute sp_adduser 'test','test','testgroup' go grant update,insert on customers -- YOU CAN DEFINED WHICH TABLE YOU WANT GRANT TO TEST USER to testgroup
execute sp_addlogin 'test','1234','Northwind',null
go
--Create a group
execute sp_addgroup 'testgroup'
go
--Add the test user to Database
execute sp_adduser 'test','test','testgroup'
go
grant update,insert
on customers -- YOU CAN DEFINED WHICH TABLE YOU WANT GRANT TO TEST USER
to testgroup
其实我想做的就是让一个用户在某段时间内超越原先分配给它的权限去执行一些特定操作,
我知道这可以用存储过程实现,但我现在想用应用程序角色来试试,不知道可行吗?
不管怎么样,还是要谢谢各位的回答:)