May 8, 2009 at 3:39 am
There are two roles in my database test test_role1 and test_role2.What I want to do is have test_role1 be assigned to developers who have to create tables, alter tables, execute sp, alter sp, create sp. I also want test_role1 to be able to grant execute permissions to specific sp’s so that anyone belonging to test_role2 can execute those specific sp’s. I believe the create table, alter table, execute sp, alter sp, create sp does work but I do not think the ability works for a user belonging to test_role1 to add grant execute to specific sp’s to test_role2.
I have created the two roles and while adding the test_role2 in the securables of test_role1 it is giving an error saying that "Index was out of range, Must be non negative and less than the size of the action.Parameter name Index(mscorlib)"
May 22, 2009 at 1:19 pm
Hi,
If I got you correctly, you want to provide the right for role1 to grant some permission to role2. In this case you can use the grant command with the WITH GRANT option. Something like this:
GRANT EXECUTE ON OBJECT::dbo.spExample TO role1 WITH GRANT
This will give a bit more permission to role1, that is, they can grant the permission to anyone, but it might be acceptable for you.
-- Erik http://blog.rollback.hu
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply