How to Deploy GRANT EXECUTEs with the stored procedures

Forum for users of SQL Compare schema synchronization utility

How to Deploy GRANT EXECUTEs with the stored procedures

Postby mshupe » Mon May 13, 2013 6: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 8:13 pm
Location: Tampa, Florida

Postby Brian Donahue » Thu May 16, 2013 7: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: 6590
Joined: Mon Aug 23, 2004 9:48 am

Return to SQL Compare Previous Versions

Who is online

Users browsing this forum: No registered users and 1 guest