CODEWITHSUNDEEP
oracle-databaseoracle10g
Rahbee Alvee
Rahbee Alvee

Reputation: 1994

Encryption inside oracle

In dot net i can use dll file so that my code is safe from others. But is there any ways so that none can see the code of some of my procedures and triggers ...

Upvotes: 4

Views: 476

Answers (2)

Dinesh Bhat
Dinesh Bhat

Reputation: 106

You could try the following approach. Note: I have never tried this approach for hiding code, but could apply in your case.

  1. create another schema with synonyms that point to all required code from the original schema.
  2. restrict access to the original schema only from the new schema, thus hiding code.
  3. Use the new schema for public access.

I have code that can create such a schema as a sample. Take a look and see if the approach works for you.

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

Upvotes: 2

Tony Andrews
Tony Andrews

Reputation: 132580

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

Upvotes: 9

Related Questions