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