SBendBuckeye
Programmer
Hello all,
We are running SqlServer 2005. For my current project, there is a group defined to which we need to Grant Execute permission for all select stored procs. I have been manually adding the group by right clicking the stored proc and then choosing Properties, Permissions, etc.
I'm thinking there has to be a way to script this and make it faster and less error prone if I forget one.
A. Can I script this process to pass in the StoredProc name and then have it add the group for me?
B. Can I write a script like A that only adds the group if it does not already exist?
C. Can I write a script that returns this information for every stored proc in the database?
Sorry if these are really obvious questions. Thanks in advance for any ideas and/or suggestions!
We are running SqlServer 2005. For my current project, there is a group defined to which we need to Grant Execute permission for all select stored procs. I have been manually adding the group by right clicking the stored proc and then choosing Properties, Permissions, etc.
I'm thinking there has to be a way to script this and make it faster and less error prone if I forget one.
A. Can I script this process to pass in the StoredProc name and then have it add the group for me?
B. Can I write a script like A that only adds the group if it does not already exist?
C. Can I write a script that returns this information for every stored proc in the database?
Sorry if these are really obvious questions. Thanks in advance for any ideas and/or suggestions!