How to decrypt stored procedure in sql?

Subash

10y1.8k

For the security reason we encrypt stored procedure by using With Encryption but my question is how we decrypt it for further modifition

10 Replies

Know the answer? Post it — somebody with the same question will find it here.

Andrew Jackson10y ago
Accepted answer
great Share! you can use XOR decryption process see here: https://www.systoolsgroup.com/sql-backup-recovery.html
+2
Bikesh Srivastava10y ago
Hi,
You can prefer this link.
https://www.mssqltips.com/sqlservertip/2964/encrypting-and-decrypting-sql-server-stored-procedures-views-and-userdefined-functions/
+1
Vasanth Natarajan10y ago
Hi.,
I have resolved this problem. My Solution: use tool SQL Compare. You must create one database to compare sql script. Return result script sql is decrypted.
http://www.red-gate.com/products/sql-development/sql-compare/
0
Afzaal Ahmad Zeeshan10y ago
As already suggested, using the key which was used for encryption. You must have shared some of the password-like credentials there. What were they? Use them to get the data back.
0
Subash10y ago
Afzaal Ahmad ZeeshanThanks for your Reply but My Question is how we decrypt the already encrypted stored procedure in Sql
0
Subash10y ago
Thanks to Share your Experience
ketan borsdiya
0
ketan borsdiya10y ago
No, I tried so many things but I didn't get any solution..
It may be possible to available in newer version of SQL Server.
0
Subash10y ago
Thanks Kethan is there any special way to decrypt it?
0
ketan borsdiya10y ago
Hi Subash,
For modification in encrypted stored procedure you have to Paste whole procedure and remove with encryption after that alter procedure.
After modification rewrite "With Encryption" and alter it.
0
Afzaal Ahmad Zeeshan10y ago
You can perform the encryption and decryption of the data using the same IV and the Key that is being used for the encryption. If you don't have that key and that IV you may not be able to get the stored procedure back.
I have written an article that covers the encryption and decryption of the data (one thing to note here is that encryption doesn't have to be with string text, it basically works on bytes of the data). You should consider reading the post here, on C# Corner at, http://www.c-sharpcorner.com/UploadFile/201fc1/guide-for-building-C-Sharp-apps-on-ubuntu-cryptographic-helpers/.
Now what you should do is to get the Key and IV of the encryption string from the security team of your development environment. Once you get that, you can decrypt the bytes of data (of the stored procedure) and get the data back to update the logic of that function.
publicstaticstringDecrypt(byte[]data)
{
stringmessage=null;
//Instantiatethealgorithm
using(varrjndl=newRijndaelManaged())
{
//Setuptheproperties
rjndl.Key=key;
rjndl.IV=iv;
//Createthememorystreamwiththebytesofdata
using(MemoryStreamstream=newMemoryStream(data))
{
//Createthestreamwiththedecryptors
using(CryptoStreamcStream=newCryptoStream(stream,rjndl.CreateDecryptor(),CryptoStreamMode.Read)){
//Createastreamreaderforthecryptostream
using(StreamReaderreader=newStreamReader(cStream))
{
//Readthedatatotheend.
message=reader.ReadToEnd();
}
}
}
}
//Returnthemessage.
returnmessage;
}
This code would do the trick (it was taken from that article of mine). All this needs is the IV and the key for your algorithm.
0

How to decrypt stored procedure in sql?

Afzaal Ahmad ZeeshanThanks for your Reply but My Question is how we decrypt the already encrypted stored procedure in Sql