Steve Dell
SSCarpal Tunnel
Points: 4621
More actions
April 12, 2011 at 4:13 pm
#238366
Hi!
can some one provide me with the query to grant execute permissions for user defined stored procedures , Thanks in advance 🙂
Steve Jones - SSC Editor
SSC Guru
Points: 728159
April 12, 2011 at 4:38 pm
#1310748
First, create a role for this. Don't use individual users.
second, this script can help. Grant the permissions to the role, add the users to the role.
http://qa.sqlservercentral.com/scripts/Maintenance+and+Management/31186/
Follow me on Twitter: http://www.twitter.com/way0utwest Forum Etiquette: How to post data/code on a forum to get the best help My Blog: www.voiceofthedba.com
Grant Fritchey
Points: 397721
April 13, 2011 at 5:41 am
#1310945
In addition to roles, also use schemas. That way you can grant execute permissions for a role to a schema. It makes things much easier to manage as Steve says.
----------------------------------------------------The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood... Theodore RooseveltThe Scary DBAAuthor of: SQL Server 2017 Query Performance Tuning, 5th Edition and SQL Server Execution Plans, 3rd EditionProduct Evangelist for Red Gate Software
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply