Erman Arslan's Oracle Forum › Database

Encrypt Table Data

Classic

List

Threaded

2 messages Options

kvmishra

Encrypt Table Data

Dear Sir,

We have created a table in 19c ST Oracle Database. In that table, we are storing some user credentials like Username and Password. Currently, we can see the UN and PWD from the database like select * from dv_users...

Now, We want to encrypt the all passwords of the table (column PASSWORD).

I've attached the ss for the referece.

Could you please help me on this?

Thanks
Vikash

ErmanArslansOracleBlog

Re: Encrypt Table Data

Administrator

This post was updated on .

You can create your own encryption/decryption mechanism (for instance your apps can store the data in encrypted mode in the database tables, decrypt the stored encrypted data(user-pass for instance) during the login process etc..) or you can use Oracle Transparent Data Encryption (but this requires license) + Redaction.

Using only the TDE is not enough for your need.. -> Protect data in tablespaces with transparent data encryption (TDE) and dynamically mask sensitive data returned by database queries with data redaction..