设为首页 加入收藏

TOP

oracle加密procedure的方法
2018-01-16 14:49:41 】 浏览:43
Tags:oracle 加密 procedure 方法

对于oracle object的加密方式

一、利用wrap加密

如下是一个测试的procedure:

[oracle@orclrac1:/home/oracle]$cat sp_test.sql

create or replace procedure leo(i in number)

as

begin

dbms_output.put_line('input parameter: '||to_char(i));

end;

如下是加密过程:

[oracle@orclrac1:/home/oracle]$wrap iname=sp_test.sql oname=sp_test_jm.sql

PL/SQL Wrapper: Release 11.2.0.1.0- 64bit Production on Wed Nov 08 14:06:58 2017

Copyright (c) 1993, 2009, Oracle. All rights reserved.

Processing sp_test.sql to sp_test_jm.sql

如下是加密完成之后的显示内容:

[oracle@orclrac1:/home/oracle]$cat sp_test_jm.sql

create or replace procedure leo wrapped

a000000

354

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

7

6b ae

eLucoK2tPHT0oy+WjvSukeA9+fUwg5nnm7+fMr2ywFyFodexpcOl0l6lmYEywLIlXQbAdIsG

wMAy/tKGBgmm+x9Jmo8wtVDIqVAvAMpK/gjSxz1pckfVFmLMFlpW8kcuYqFiwglpZCa9CNC/

M7h0JaV3d6CLBsCBx/vxdKa1unZI

/

对存储过程做编译,并可顺利执行:

[oracle@orclrac1:/home/oracle]$sqlplus zq/oracle

SQL*Plus: Release 11.2.0.1.0 Production on Wed Nov 8 14:07:03 2017

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> @sp_test_jm.sql

Procedure created.

SQL> set serveroutput on;

SQL> exec leo(100);

input parameter: 100

PL/SQL procedure successfully completed.

查看oracle的数据字典中的显示:

SQL> select name,text from user_source where type='PROCEDURE' and name='LEO';

NAME

----

TEXT

-------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

LEO

procedure leo wrapped

a000000

354

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

abcd

7

6b ae

eLucoK2tPHT0oy+WjvSukeA9+fUwg5nnm7+fMr2ywFyFodexpcOl0l6lmYEywLIlXQbAdIsG

wMAy/tKGBgmm+x9Jmo8wtVDIqVAvAMpK/gjSxz1pckfVFmLMFlpW8kcuYqFiwglpZCa9CNC/

M7h0JaV3d6CLBsCBx/vxdKa1unZI

】【打印繁体】【投稿】【收藏】 【推荐】【举报】【评论】 【关闭】 【返回顶部
上一篇oracle数据库还原后怎么将dmp文件.. 下一篇.NET/C#/Oracle数据库操作类实例..

最新文章

热门文章

Hot 文章

Python

C 语言

C++基础

大数据基础

linux编程基础

C/C++面试题目