Oracle 10g new features-code obfuscation, stored procedure encryption

Oracle 10g new features-code obfuscation

Author: Fuyuncat

Source: www.HelloDBA.com

Oracle 9i Previously, a command ' warp ' was provided to encrypt the code. But it's command-line, it's script-oriented. In 10g, Oracle Package DBMS_DDL provides a new function create_wrapped to confuse the code. Example: Sql> Declare 2 V_protex varchar2 (2000): = ' 3 CREATE OR REPLACE PROCEDURE p_wraptest 4 is 5 V_count number; 6 BEGIN 7 Select COUNT (*) into the v_count from User_tables; 8 Dbms_output. Put_Line (' Tables number is: ' | | v_count); 9 End; 10 '; Begin The SYS. Dbms_ddl. Create_wrapped (V_protex); The end; 14/ Pl/sql procedure successfully completed Then look at the confusing code: sql> SELECT text from user_source WHERE name = ' P_wraptest '; TEXT -------------------------------------------------------------------------------- PROCEDURE P_wraptest Wrapped a000000 367 Abcd Abcd Abcd Abcd Abcd Abcd Abcd Abcd Abcd Abcd Abcd Abcd Abcd Abcd Abcd 7 A0 db P9j84ore7zt5hy6ayflid/b/8ymwgwbf2ssvfc+ijhayzffpukzxltm5k5uum9gjb/cjyvte 80zl0ai2lsfoiy6xzizux8j8bnd0s8hl6azuckp25+esapoeakn9ow9qaxvoft8kqbkotyy+ gchxfoqrjwpme3cjliplboieddlfcjqzmryw1xqa0ejcr3ka5lsfm9qrgt1wgrqqpg5d1y8=