oracle加密工具

来源：互联网发布：c语言简单的图形编程编辑：程序博客网时间：2024/06/10 01:36

见官方文档中描述加密工具wrap:http://docs.oracle.com/cd/E11882_01/appdev.112/e17126/wrap.htm#LNPLS1744

语法：wrap iname=input_file [ oname=output_file ]

示例：

wrap iname=/mydir/myfile
wrap iname=/mydir/myfile.sql oname=/mydir/myfile.plb

wrap iname=/mydir/myfile.src oname=/yourdir/yourfile.out

SQL> @myfile.plb;

如一个Sql文本

-- The following statement will not change. This comment will be deleted. SELECT COUNT(*) FROM EMPLOYEES/ /* The PL/SQL source text of the following two CREATE statementswill be wrapped. This commment will not be deleted. */ CREATE PROCEDURE wraptest AUTHID DEFINER IS  TYPE emp_tab IS TABLE OF employees%ROWTYPE INDEX BY PLS_INTEGER;  all_emps  emp_tab;BEGIN  SELECT * BULK COLLECT INTO all_emps FROM employees;  FOR i IN 1..10 LOOP    DBMS_OUTPUT.PUT_LINE('Emp Id: ' || all_emps(i).employee_id);  END LOOP;END;/ CREATE OR REPLACE FUNCTION fibonacci (  n PLS_INTEGER) RETURN PLS_INTEGERAUTHID DEFINERIS  fib_1 PLS_INTEGER := 0;  fib_2 PLS_INTEGER := 1;BEGIN  IF n = 1 THEN                              -- terminating condition    RETURN fib_1;  ELSIF n = 2 THEN    RETURN fib_2;                           -- terminating condition  ELSE    RETURN fibonacci(n-2) + fibonacci(n-1);  -- recursive invocations  END IF;END;/

经过加密后的文本

SELECT COUNT(*) FROM EMPLOYEES//* The PL/SQL source text of the following two CREATE statementswill be wrapped. This commment will not be deleted. */CREATE PROCEDURE wraptest wrapped a000000b2abcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcd7121 134Pf3/wD+9ncRZhp3XxTMUO3yIRvswg+nQ7UhqfHRG2vg+SD7x9XzsDUFWbdwCJVEOLKBBRuH6VMoRHfX6apzfyMkvWhzQLCYvAcq6Zu7++E7PrXNxUJzk/FZW8P9eRgyyyMFnDj53aP1cDje9ZdGr2VmJHIw0ZNHBYhDdR+du5U5Yy47a6dJHXFW9eNyxBHtXZDuiWYTUtlnueHQV9iYDwE+rjFn+eZm4jgDcTLTEzfmIVtPDRNhYCY3xhPo7vJeS8M1AvP+4xh9+uO35XsRIsRl1PTFVrGwg6iuxETwA5Pu2mwx3 /CREATE OR REPLACE FUNCTION fibonacci wrapped a000000b2abcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcdabcd814a fbe1Yq3QQJoEoNKIeJlbgLoLdSgogwgxDcf8vWfHSKbuowFOXFKoj9MqYGqWyRxeeCUVqNVIO1ICqJa3yPr6e7z8GZpMH3J0Cx0uQ0B1JuysymdNDlzfTvb7QWsrLU4jGs3h8Mm49/L9nyO4XhAe06nawFpOJIAYpBf9wBVC+ZrjU/nuEtokBqCce6HWIoF6rYgz0V0W/47x5KpOnQ2i7X3kFeFR8K7jT7X58k8xK9uYlZv5LhV71a7A== /

加密后文本通过查找源中看到的依然是加密后的文本

SQL> SELECT text FROM USER_SOURCE WHERE name='WRAPTEST';

0 0