oracle 加密
利用oracle wrap 可以对函数和procedure等源码进行加密
如sql:test1.sql
create or replace procedure lerry.my_proc
as
i number;
begin
for i in 1..1000 loop
insert into lerry.t1 values(i,i);
end loop;
commit;
end;
as
i number;
begin
for i in 1..1000 loop
insert into lerry.t1 values(i,i);
end loop;
commit;
end;
tyan147oracle:/home/oracle>wrap iname=test1.sql
PL/SQL Wrapper: Release 11.2.0.1.0- 64bit Production on Tue Aug 28 11:01:22 2012
Copyright (c) 1993, 2009, Oracle. All rights reserved.
Processing test1.sql to test1.plb
$cat test1plb
create or replace procedure lerry.my_proc wrappeda000000
1
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
abcd
7
74 b2
WALPWW3vlRdDMexjo1W2xOWrUdcwg6SX2p5qfHSmUP97AtQ2rC0XrjpNNXAMNWEdkHv1y2JV
wPin2NDEWP+gIe96/8HB+D+vVKnMo0GFZlmgwt1MsoiTfFcfNP51w3hwPpGBclx/9zFqPan4
dauNSlu578hW6vB89v9xlvTELDblpIk=
tyan147oracle:/home/oracle>sqlplus / as sysdba
SQL*Plus: Release 11.2.0.1.0 Production on Tue Aug 28 11:01:28 2012
Copyright (c) 1982, 2009, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> @test1.plb
Procedure created.
查看是否已加密
sqlplus / as sysdba
sql>select * from dba_source where name='TEST1';
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/24849178/viewspace-742053/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
最新文章
- ORA-39213: Metadata processing is not available
- RAC oracle 权限更改导致 实力启动失败
- ORA-08102: 未找到索引关键字
- CBO的运行模式first_rows,all_rows
- ORA-06512: at "SYS.DBMS_DATAPUMP", line 4052
- SP2-0611: Error enabling STATISTICS report
- 11gr2 RAC注册database，listener 到CRS
- tns listner 监听连接很慢
- ORA-06512: at "PERFSTAT.STATSPACK", line 2134
- ORA-12528: TNS:listener: all appropriate instances are blocking new connection
