ASKTOM - Transparent Data Encryption

ASKTOM - Transparent Data Encryption

REFERENCE:
   http://asktom.oracle...ON_ID:44742967463133
   http://download-east...otrans.htm#sthref142

ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY password
ALTER SYSTEM SET WALLET OPEN IDENTIFIED BY password

CREATE TABLE table_name ( column_name column_type ENCRYPT,....);
ALTER TABLE table_name MODIFY ( column_name column_type ENCRYPT,...);
ALTER SYSTEM SET WALLET CLOSE

Using an external security module separates ordinary program functions from 
encryption operations, making it possible to divide duties between database 
administrators and security administrators. Security is enhanced because no 
single administrator is granted complete access to all data.

REFERENCE:
   http://download-east...otrans.htm#sthref142