Tags: all_source, body, code, database, dear, hide, method, mysql, oracle, package, source, sql, table, users

ALL_SOURCE table

On Database » Oracle

1,018 words with 3 Comments; publish: Fri, 08 Feb 2008 11:49:00 GMT; (25062.50, « »)

Dear all,

Is there any method to hide my package body? I do not want the users to get my source code from ALL_SOURCE table, thanks.

Regards,

George

All Comments

Leave a comment...

  • 3 Comments
    • Hi,

      using wrap utility you will get the the .pll file. Which contains the codein hexadecimal format, when u compile this file instead of the .sql file, your code will be in hexa decimal format, so that you can't figure out the exact text from user_source.

      just run this from the ORACLE_HOME/BIN OR SET THE PATH TO THIS DIRECTORY.

      wrap iname=inputfilename.sql oname=outfilename

      all the best

      Khaleel

      #1; Thu, 21 Feb 2008 18:14:00 GMT
    • Hello,

      Thanks for reply.

      Actually in my environment, I can select the package (header) from all_source, but I can't find the package body. So I just wonder how the DBA does this.

      Regards,

      George

      #2; Thu, 21 Feb 2008 18:15:00 GMT
    • Hi George,

      I think that's because only the DBA has the privilege to view the source code. Your DBA has set the privilege of the user login so the user login can only view the header.

      #3; Thu, 21 Feb 2008 18:16:00 GMT