Object decryption Permission Level

Johan Van Hoye

I could not find anything in the online documentation relating to how SQL Compare does its decrypting of encrypted stored procedures. More specifically I would like to know whether this feature requires a certain privilege level in SQL Server?
What is the minimal server role membership / fixed database role membership, or is there none?

Brian Donahue

Hello Johan,

You'll need a sysadmin or securityadmin role on the server to decrypt objects. Basically you need the rights to run DBCC commands against the server.

If you do not have the necessary rights, then SQL Compare will simply say 'the object's text has been encrypted'.