How to Deploy GRANT EXECUTEs with the stored procedures

Compares and synchronizes SQL Server databases, backups and scripts.

Moderators: JonathanWatts, Chris Auckland, David Atkinson, eddie davis, Anu Deshpande, Michelle Taylor, alice.easey, james.billings, chengvoon.tong

How to Deploy GRANT EXECUTEs with the stored procedures

Postby mshupe » Mon May 13, 2013 7:58 pm

I compared two databases and deployed the differences. Unfortunately, the GRANT EXECUTE statements were not deployed along with the stored procedures. How can I have them included?
Note that there are forum entries about how to ignore the GRANT EXECUTE differences and I have figured that out but I am trying to do the opposite. I am trying to ensure that the GRANT EXECUTEs are included.
It looks like SQL Compare does not display the GRANT EXECUTEs on the source side at all. If I understand correctly, one of the forum entries said that only GRANT EXECUTEs for the current user would be displayed. I need all of them. Please let me know how I might do this.
Posts: 2
Joined: Tue May 07, 2013 9:13 pm
Location: Tampa, Florida

Postby Brian Donahue » Thu May 16, 2013 8:23 am


As you've probably figured out, there is an option to ignore permissions, so by default they are included. There may be some subtlety if the permissions are granted at database-level rather than object-level so it would be good to know if you are applying permissions at database-level.

Also, if this is concerning the command-line, please let us know as there is generally lots of confusion around how to apply the options.
Brian Donahue
Posts: 6670
Joined: Mon Aug 23, 2004 10:48 am

Return to SQL Compare 10

Who is online

Users browsing this forum: No registered users and 1 guest