Reputation: 3437
Is there a way to hide the code behind the stored procedures even from DBA/sa for an application that will be installed/maintained at the client side by the client itself?
I saw there is an option to use WITH ENCRYPTION
clause while a SP is created, but it seems that code can be easily decrypted.
Upvotes: 0
Views: 1350
Reputation: 71
http://www.codeproject.com/Tips/353459/A-simple-hack-of-a-built-in-MS-SQL-Server-WITH-ENC
Talks about a client side tool for encrypting procedures. The article claims it isn't decryptable via all the usual tools people use, so it may meet your needs.
Upvotes: 1