Geek Answers Handbook

Oracle encryption

In dot net, I can use a dll file so that my code is safe for others. But are there any ways that no one can see the code of some of my procedures and triggers ...

+4
source share
2 answers

You can transfer procedure code to make it unreadable. You cannot wrap the trigger code, but you can move the trigger code to a stored procedure so that the trigger code contains nothing more than a wrapped procedure call.

+9
source

You can try the following approach. Note: I have never tried this approach to hide code, but could be applied in your case.

  • create another schema with synonyms this indicates all the required code from the source schema.
  • restrict access to the original schema only from the new schema, thus hiding the code.
  • Use the new scheme for sharing.

I have code that can create such a scheme as a sample. Take a look and see if the approach suits you.

http://1smallthought.blogspot.com/2008/06/creating-shortcut-to-schema-using.html

+2
source

More articles:


All Articles