Tags: all_source, body, code, database, dear, hide, method, mysql, oracle, package, source, sql, table, users
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.
Leave a comment...
- 3 Comments
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
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.
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