Encrypted stored procedure, in other users perform

As the social division of labour and cooperation and more closely, in the same server may run several companies different service product, sometimes services provide data between each other, to achieve win-win situation on the economy; and of course their own security and independence also needs to be ensured.

If such a service in the background using the ORACLE database, you can use the encrypted stored procedures, and in other users perform. First of all we want to provide the data to write a proper logical stored procedure or function, assuming that the source is test_proc test.sql. Then wrap utility (the default directory $ ORACLE_HOME/bin) encryption it: use wrap syntax is: $ wrapiname = input_file [oname = output_file] ↑ ↑ encrypted stored procedures or functions before the encrypted stored procedures or functions, the default suffix * .plb for example: $ wrapiname = test.sql will result in the current directory test.plb encrypted stored procedures or functions Note: Windows and UNIX platforms for next generation * .plb wrap encrypted files can be generic, version is upward compatible. Finally, compile the encrypted test.plb SQL > & nbsp @/tmp/test.plb and gives the user the related cooperation (another_user) SQL > Execute permissions; grantexecuteontest_proctoanother_user Other considerations: cooperation users can't have too many permissions, so that they cannot find the data dictionary and other users, a table, the password you want to get up to some.