This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(297.6, 41%, 38%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3ECD%3C/text%3E%3C/svg%3E)
Hi All,
Is there a way to encrypt stored procedure code with password ?. I am not talking about the keyword "WITH ENCRYPTION" in the stored procedure when creating it but actually applying a password to it so that I can also decrypt it with that password. Don't want to create a master key and certificate for it either. Is there a way ? This is for any SQL Server versions from 2012 to 2019.
Thanks.
What is your use case for needing this? Typically, one keeps stored procedures in source control to avoid reverse engineering existing database objects.
No. Think of it. To be able to run the stored procedure, SQL Server needs to be able read the SQL code. So if there were such a feature, user would only be able to run the procedure if the user has the password.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(92.8, 34%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAV%3C/text%3E%3C/svg%3E)
Another way of doing it would be locking the procedure, which is handled by DB Admin. In this way, Company ending their contract will not be able to download or even look at the stored proc's.
This also helps to reuse if it needs to be implemented in any other company.
--please don't forget to Accept as answer if the reply is helpful--
Sorry, but you completely missed what it is all about. Application locks has no relation to what Carlos is asking for. They are a great feature for several things, for instance like making sure that not two instance of the same procedure runs at the same time. But they have nothing to with permissions. And anyone can use them - it does not have to be a DB Admin.
Furthermore, in Carlos's case, he also concerned what DB admins or sysadmins can do, since these are people working for the customer.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(96, 0%, 19%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EFT%3C/text%3E%3C/svg%3E)
I have same problem, I want to do store procedure encryption with password, want to hide the logic behind the procedures...
Is there any way around for Procedure encryption with password or any other type of decryption.
If you want to hide the logic in the procedure, you need to avoid that users get permission to read the procedure code. To do this, you cannot permit installation at a customer site, but you need to host the procedure yourself, for instance in Azure SQL DB.
As for why, see my Answer above.
As told you that would not be solution, as I have to host on the demand of client
Well, then you cannot not hide your logic.
But a good license agreement which controls what the customer can do and not do with the code is a good idea.