存储过程加密

[SIWEILIULANG]

请问存储过程可以加密吗？
这样别人即使打开数据库，也看不到，也算是一种保护吧。

[liangCK]

with encryption

[liangCK]

CREATE { PROC | PROCEDURE } [schema_name.] procedure_name [ ; number ] 
    [ { @parameter [ type_schema_name. ] data_type } 
        [ VARYING ] [ = default ] [ [ OUT [ PUT ] 
    ] [ ,...n ] 
[ WITH <procedure_option> [ ,...n ]
[ FOR REPLICATION ] 
AS { <sql_statement> [;][ ...n ] | <method_specifier> }
[;]
<procedure_option> ::= 
    [ ENCRYPTION ]
    [ RECOMPILE ]
    [ EXECUTE_AS_Clause ]

<sql_statement> ::= 
{ [ BEGIN ] statements [ END ] }

<method_specifier> ::=
EXTERNAL NAME assembly_name.class_name.method_name

[liangCK]

create proc p
  @i int ,@o int out
with encryption
as
   --sql
go

[SIWEILIULANG]

能否详细点说明

[昵称被占用了]

带with encryption创建存储过程

[nzperfect]

create proc p
@i int ,@o int out
with encryption
as
--sql
go

没什么用,可以解密的

[JiangHongTao]

加上 with eneryption 对一般人有用，但可以解密。

[zefuzhang2008]

在sql2000中，
即使加密，别人看不到代码，但可修改

create proc t 
with   encryption
as
select * from t 

alter proc t
as
select 1

另外，不论2000还是2005，都可以解密