Oracle Wallet with encrypted column values
HI,
We have an requirement to encrypt sensitive data of some of the table's columns for security compliance purpose. We are on Oracle 11gR2 on Linux platform.
We tried to test it out by using TDE - Oracle Wallet. Below is the detail steps:
SQL> ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "SauPass";
System altered.
SQL> CREATE TABLE TEST_USER
(
USER VARCHAR2(10),
PWD VARCHAR2(30)ENCRYPT,
CREATE_DATE_TIME DATE,
MOD_DATE_TIME DATE
);
Table created.
SQL> INSERT INTO TEST_USER VALUES(‘abcde’,'xyzer’,sysdate,sysdate);
1 row created.
SQL> commit;
Commit complete.
SQL> select * from test_user;
USER PWD CREATE_DA MOD_DATE_
---------- ------------------------------ --------- ---------
abcde xyzer 06-SEP-12 06-SEP-12
Connect as sys:
SQL> ALTER SYSTEM SET ENCRYPTION WALLET CLOSE IDENTIFIED BY "SauPass";
System altered.
Connect saurabh:
SQL> select * from test_user;
select * from test_user
*
ERROR at line 1:
ORA-28365: wallet is not open
SQL> SELECT USER FROM TEST_USER;
USER
----------
abcde
But the problem is when I try to retrieve all the records from that table its throwing error "ORA-28365: wallet is not open". I want that when I fire query "select * from table_name" then it should show any encrypted values for encrypted column name along with rest of column values.
Actually I dont know this is possible with wallet or not, if anyone knows any alternative or solution, please reply.
Thanks,
Saurabh
Edited by: 877938 on Sep 6, 2012 3:08 AM