Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Transparent Data Encryption

in Autonomous Database 4 comments

We are trying to use Transparent Data Encryption for encrypting columns in Oracle ATP database.

we have used the below query for creating a table with encrpted column, but when we try to retrive the data using sql or ORDS its behaving as ordinary column & giving the data as it is.

CREATE TABLE employee (

   first_name VARCHAR2(128),

   last_name VARCHAR2(128),

   empID NUMBER,

   salary NUMBER(6) ENCRYPT)

 

kindly let us know if am doing anything wrong.We are refering to the below blogs for TDE.

https://docs.oracle.com/en/database/oracle/oracle-database/21/asoag/encrypting-columns-tables2.html#GUID-A0E2C279-10F6-48D9-AB92-C547529C06EE

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!