How can we help you today? How can we help you today?

Object decryption Permission Level

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?
Johan Van Hoye
0

Comments

1 comment

Sort by
  • 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'.
    Brian Donahue
    0

Add comment

Please sign in to leave a comment.