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
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
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.
- 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