BUG: Sql compare 13 flags GRANT EXEC as different than GRANT EXECUTE

jamaljamal Posts: 41 Bronze 2
edited March 13, 2018 3:18PM in SQL Prompt Previous Versions
I noticed the only difference in a stored procedure script that was being flagged by Sql Compare 13.1.11.5591 as different between the script and the server was EXEC vs EXECUTE in a grant statement. I did the same compare using SQL Compare 12.2.1.4077 and the difference was not flagged. Is there an option to stop this from being flagged in SQL Compare 13? Here's a screenshot of the v13 difference: 4z1ekdh1xlc7png
James

Comments

  • jamaljamal Posts: 41 Bronze 2
    edited March 9, 2018 7:50PM
    And the resulting deploy script does this:
    PRINT N'Altering permissions on [dbo].[GetWebinarEmailsAsFetchXmlValues]'
    GO
    GRANT EXEC ON [dbo].[GetWebinarEmailsAsFetchXmlValues] TO [xxxx]
    GO
    REVOKE EXECUTE ON [dbo].[GetWebinarEmailsAsFetchXmlValues] TO [xxxx]

    which actually revokes the permission it just gave resulting in a real difference and creates a never ending loop of differences if you continue to run the deploy scripts one after the other.
    James
  • jamaljamal Posts: 41 Bronze 2
    edited March 13, 2018 7:45PM
    (removed)
    James
Sign In or Register to comment.