Got error when Implementing VPD policy
Dear all
I am working on securing one table for secure transaction. I had installed one database and created one tablespace for the application.
The tablespace of size 100M containing one table of One row only.
I had configured the wallet and it is open. The table structure is like this:
CREATE TABLE "puser"."merchant" (
"CLIENT_ID" VARCHAR2(16),
"ACCESS_CODE" VARCHAR2(8),
"USER_ID" VARCHAR2(20) ENCRYPT USING 'AES256' ,
"PASSWORD" VARCHAR2(25) ENCRYPT USING 'AES256',
"SECUREKEY" VARCHAR2(33) ENCRYPT USING 'AES256')
TABLESPACE "MERCHANTTBS"
The tablespace is not encrypted. I had used to encrypt the three feilds but when I select from the table, I still can see the real values in clear text, not ecrypted.
I am working on securing one table for secure transaction. I had installed one database and created one tablespace for the application.
The tablespace of size 100M containing one table of One row only.
I had configured the wallet and it is open. The table structure is like this:
CREATE TABLE "puser"."merchant" (
"CLIENT_ID" VARCHAR2(16),
"ACCESS_CODE" VARCHAR2(8),
"USER_ID" VARCHAR2(20) ENCRYPT USING 'AES256' ,
"PASSWORD" VARCHAR2(25) ENCRYPT USING 'AES256',
"SECUREKEY" VARCHAR2(33) ENCRYPT USING 'AES256')
TABLESPACE "MERCHANTTBS"
The tablespace is not encrypted. I had used to encrypt the three feilds but when I select from the table, I still can see the real values in clear text, not ecrypted.
0