SQL Compare 14 Permissions for Decryption of Encrypted Objects

howarthcd

The documentation at the following page:

https://documentation.red-gate.com/sc14/getting-started/requirements/permissions-required-to-use-sql-compare

...suggests that objects can be decrypted (SQL 2008 and later) by a login with the VIEW SERVER STATE permission, yet this doesn't appear to be the case in practice. It doesn't make sense for the login performing the comparison to be a member of the 'sysadmin' server role and to be granted the VIEW SERVER STATE permission as the 'sysadmin' server role essentially has that permission implicitly.

Please could you clarify the requirement?

SQL Compare 14.0.0.12866 Professional

Thanks
Chris

Tianjiao_Li

Thanks for highlighting this issue and we've updated the documentation page accordingly.

Apologies for the confusion it has caused.