SQL Server：加密/保护存储过程 [英] SQL Server : Encrypt / Protect stored procedure

问题描述

我只是想知道任何好的工具或软件，你可以推荐我来保护/加密我在SQL Server 2008 R2上开发的存储过程？

I am just wondering any good tools or software that you can recommend me to protect / encrypt my stored procedure that was developed on SQL Server 2008 R2 ?

我读了关于使用加密创建存储过程，是否可能得到解密，以防程序中有错误？

I read about create stored procedure with encryption and is it possible to get it decrypted in case I have bugs in the program?

另外，遇到了CLR，但我不认为我想要在Visual Studio环境中创建一个存储过程。或者我可能是错的。

Also, came across CLR but I don't think I want to create a stored procedure in Visual Studio environment. Or I could be wrong.

希望在我仍在研究这个话题的时候给我一些建议。

Hope you can give me some advise while I am still researching on this topic.

最终目标是，我不希望人们查看我的存储过程并窃取它自己使用。

Final objective would be, I don't want people to view my stored procedure and steal it for own use.

谢谢。

推荐答案

不能使用 WITH ENCRYPTION ？
例如

Can't you use WITH ENCRYPTION? For example

CREATE PROCEDURE #EncryptSP
WITH ENCRYPTION
AS
SELECT TOP 10 City
FROM Person.Address
GO

https://msdn.microsoft.com/en-gb/library/ ms187926％28v = sql.105％29.aspx

这篇关于SQL Server：加密/保护存储过程的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！