why I can still view encrypted column after setup TDE
Hi, we need to encrypt data from users. I followed up steps with Transparent Data Encryption (Doc ID 317311.1)
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