1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle Database Encryption/Decryption

Discussion in 'General' started by Monee, Jul 20, 2009.

  1. Monee

    Monee Guest

    Friends/ Professionals,
    We are facing a problem, hope someone could help us.
    We need to transform live Oracle database in such a manner that in
    the Database - entity relationship, architecture, format, datatype etc remains as it is but
    the displayed value is a dummy or encrypted one in our local databases.
    And on running an sql script we are able to retrieve the corresponding dummy data only.
    Please suggest your solution & why you choose the same.
  2. tyro

    tyro Forum Genius

    Likes Received:
    Trophy Points:
    So you want to store the data in it'd original form but not allow select statements on it, right? How can that work? if you give someone select access, he will be able to select the actual data. If you don't want unauthorized access, enhance your security model. Oracle is pretty secure even with all default settings.

    But if you are asking the reverse, it is very much possible. I mean one can always access the data by connecting to the database but data storage can be easily encrypted with Transparent Data Encryption.
  3. apunhiran

    apunhiran Active Member

    Likes Received:
    Trophy Points:
    You can also use DBMS_OBFUSCATION_TOOLKIT to encrypt and decrypt data.
    Please refer to oracle-base.com/articles/8i/DataEncryption.php. It gives an example how to use this package.