Database Security Products (MOSC)

MOSC Banner

Encrypt Table Column

edited Aug 7, 2012 3:15AM in Database Security Products (MOSC) 7 commentsAnswered
Once table column is encrypted, as sysdba, I still can see the encrypted data in text mode. 

And if to close the wallet, the column will not able to view.

SQL> select * from encryp_t;
select * from encryp_t
*
ERROR at line 1:
ORA-28365: wallet is not open

And according to the user guide --> In most cases, leave the wallet open unless you have a reason for closing it. You can close the wallet to disable access to the master key and prevent access to the encrypted columns.

Please advice what are the right procedure and normal way for implementing such features.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center