What are the challenges you face when working across database platforms? Take the survey

Object decryption Permission Level

Johan Van HoyeJohan Van Hoye Posts: 12
edited June 21, 2005 8:53AM in SQL Compare Previous Versions
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?


  • Options
    Brian DonahueBrian Donahue Posts: 6,590 Bronze 1
    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'.
This discussion has been closed.