Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Data encryption in Oracle 19c

Status
Not open for further replies.

rk68

Programmer
Jul 15, 2003
172
IN
Hi,
I am using Oracle 19c Enterprise Edition Release 19 (without Advance Security license). If I go for Advance Security license, as per the Oracle website, it mentions that I will be able to encrypt the database or table columns etc.
But I am still not clear on couple of things like-
a) whether I need modify existing tables & also on the frontend should I make changes in my codes to extract the encrypted data
b) will it be possible to see the encrypted data in PL/SQL developer by using simple SQLs

Or is there any other way to encrypt data without Advance Security license. I have written an Oracle Function to Decrypt/Encrypt data. So in the frontend apps, I have to use this function to decrypt the data while displaying data & encrypt data at time of inserting/updating data. I have done the above only for login passwords fields only. I need to encrypt more key fields from multiple tables. Is it the only way using the function to decrypt/encrypt data or going for Advance Security license. Since there is costing involved in going for the license, I am looking for other options.

Please let me know your views, ideas about it . Thank you in advance.

Raj
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top