Database Security Products (MOSC)

MOSC Banner

why I can still view encrypted column after setup TDE

edited Oct 7, 2013 7:33PM in Database Security Products (MOSC) 3 commentsAnswered

Hi, we need to encrypt data from users. I followed up steps with Transparent Data Encryption (Doc ID 317311.1)

But we still can see the encrypted column. 

SQL@@VOVN09:SYS> ALTER SYSTEM SET ENCRYPTION KEY IDENTIFIED BY "abcd1234";

SQL@@VOVN09:SYS> select * from v$encryption_wallet;

 

WRL_TYPE

--------------------

WRL_PARAMETER

------------------------------------------------------------------------------------------------------------------------------------

STATUS

------------------

file

/opt/oracle/admin/VOVN09/wallet

OPEN

 

 

1 row selected.

 

SQL@@VOVN09:SYS> select * from v$wallet;

 

no rows selected

 

SQL@@VOVN09:SYS> ALTER SYSTEM SET WALLET OPEN IDENTIFIED BY "abcd1234";

ALTER SYSTEM SET WALLET OPEN IDENTIFIED BY "abcd1234"

*

ERROR at line 1:

ORA-28354: Encryption wallet, auto login wallet, or HSM is already open

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