如何在SQL Server中包装代码 [英] How to Wrap Code in SQL sever

问题描述

wrap实用程序将一个可读的ASCII文本文件作为输入，并将其转换为包含字节码的文件. 结果是DBA，开发人员或具有数据库访问权限的任何人都无法以任何可读格式查看源代码.
包装的命令行选项为:
wrap iname = [文件] oname = [文件]

以上可以在PL/Sql中实现

请参阅URL以获取更多详细信息
http://www.dba-oracle.com/t_wrap_utility.htm


如何在SQL Server中实现它

the wrap utility takes a readable, ASCII text file as input and converts it to a file containing byte code. The result is that the DBA, developers or anyone with database access cannot view the source code in any readable format.
The command line options for wrap are:
wrap iname=[file] oname=[file]

The Above is achievable in PL/Sql

Please refer the URL for More Details
http://www.dba-oracle.com/t_wrap_utility.htm


How to achieve it in SQL Server

推荐答案

如果您正在谈论加密T-SQL代码(如存储的)过程和用户​​定义函数，可以在创建它们时使用WITH ENCRYPTION选项.

If you are talking about encrypting T-SQL code like Stored Procedures and User Defined Functions, you can use WITH ENCRYPTION option while creating them.

CREATE PROCEDURE Procedure1
(
@Param1 int
)
WITH ENCRYPTION
AS
BEGIN
    ......
END

但是，请注意，这样做是一种单程票，除非将源保存到文件中以供参考，否则无法取回源.在该过程中执行生成脚本不会产生源.

However, note that doing this is a one way ticket and there is no way to get back the source unless you save the source to a file for your reference. Doing a generate script on the procedure will not yield the source.

可以与encrypion命令一起使用

请参考下面的链接

http://blog.sqlauthority.com /2008/11/01/sql-server-stored-procedure-with-encryption-and-execution-plan/

you can use with encrypion command

please refer below link

http://blog.sqlauthority.com/2008/11/01/sql-server-stored-procedure-with-encryption-and-execution-plan/

这篇关于如何在SQL Server中包装代码的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！