Encrypt Table Data

[kvmishra]

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]

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..