Sometimes you need to encrypt certain data stored in your databasedata like passwords and other condfidential information.
Oracle Obfuscation is a technique in which data is encrypted or decrypted using a key. While the key can be supplied externally, it can also be stored securely inside an Oracle-wrapped package where no one can see itincluding the DBA. The wrapped package is protected against execution by unauthorized persons; it checks for user roles and then enforces proper authority by generating exceptions when the user's role does not satisfy the authority level for execution.
Here's how to do it:
- Code an Oracle package containing the key and wrap it so that the code is visible to no one.
- Inside the package, place logic to check whether the authorized role is executing.
- Use the wrapped package to supply the key for the Obfuscation package.
- Store the encrypted data returned by the Obfuscation package into the database.
Now you data is secure from prying eyes!