Guideline for hiding EncryptionKey while using DBMS_CRYPTO.

HI

F.Y.I. Only

There are single custom user developed package which will having two customized function like encrypt and decrypt.

Four Simple steps to configure the PLSQL – DBMS_CRYPTO
1. You have to modify the EncryptionKey in this package inside encrypt function.
2. Wrapping the Package code completed and generate the sql file using Wrap Utility, (a standalone programming utility that encrypts PL/SQL source code)

3. Package source code is unreadable to anyone, even the owner of the package like DBA or Developer.
4. This way we can hide the encryption logic completely from every one.

Demo
http://oracleflash.com/41/Encrypt-or-Decrypt-sensitive-data-using-PLSQL—DBMS_CRYPTO.html

Reference
http://www.dba-oracle.com/t_dbms_crypto.htm

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.