Posted in Belajar, Oracle

Transparent Data Encryption Oracle 10g

Transparent Data Encryption

What is TDE?

  • A mechanism to encrypt sensitive information in the database.
  • Encryption is done by Oracle before writing to the disk.
  • Individual applications are not burdened with encryption if TDE facility is used.

What are the advantages of TDE?

  • Complexity of application program is reduced.
  • Applications can run as is without modification after encryption.
  • Encryption management can be done across the enterprise with common policy enforced by Oracle.

How to set up TDE?

  • Prepare the Database for encryption by editing the sqlnet.ora file to include an entry

“ENCRYPTED_WALLET_LOCATION”

  • Connect to the database as SYSDBA and create the master encryption key by executing the command

alter system set key identified by “username”

  • For later sessions the wallet needs to be open, This is done by executing the command

alter system set wallet open identified by “username”

What are the applications of TDE?

  • Creating Tables with encrypted columns
  • Creating Index on encrypted data
  • Making changes to the encrypted data

Author:

Teman yang baik, teman yang memaksa anda untuk terus berkembang...

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 )

Twitter picture

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

Facebook photo

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

Google+ photo

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

Connecting to %s