February 5, 2009 at 1:31 pm
if a developer has ddl_admin i thought it would also give him exec permissions on all the store proc with in the db but NOT. How can i setup permission so that he can exec all the SP existing and also newly created store procs automatically.
February 5, 2009 at 2:07 pm
Here is what i did
1)Create a new user defined database role
2) Select the schema to which all stored procedure belongs(1 or more) from owned schema selections
3) add the member who you want to grant the execute rights
3) go to Securables tab in same window
4) Add Securables as All objects of the types and select stored procedures
5) in the effective permissions just assign the execute permission and it should work
February 5, 2009 at 2:17 pm
YES. I just ran this it worked fine to me.
1./* CREATE A NEW ROLE */
CREATE ROLE db_executor
2. /* GRANT EXECUTE TO THE ROLE */
GRANT EXECUTE TO db_executor
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply