Hello All,
Its version oracle 19C. We are planning to go for column encryption for some of the sensitive columns which we cant really store in clear text in our database as per business requirement. And we should also be able to decrypt it in case of need. And this activity we need to do on the existing data and the newly coming data to the table. There are 100's of million rows inserted/queried per day to/from the table along with that column.
While searching over the internet , I found dbms_crypto function. But I have never used it in the past. So I wanted guidance here , if this above use case should be catered by the dbms_crypto package and if any sample example or document to start with ?
And also how the encryption key management happens here? And as we also have requirement to store key outside the current system , so as to avoid any mishap too. And if the same data going to flow to downstream system in files too , would we have to move the keys to the downstream application too to have the columns decrypted, and wont that be riskier then? Or any other possible easy/more performant methods are available in latest Oracle versions?