Good Day Sallie!
A former organization I was with decided to encrypt entire tablespaces to meet
a data-at-rest encryption security control.
It is an additional licensed option with Enterprise Edition licensing, see faq:
https://www.oracle.com/database/technologies/faq-tde.html ;
<https://www.oracle.com/database/technologies/faq-tde.html>
Said that, the above also has a redaction feature to mask sensitive data.
My apologies in advance as I don’t have a broader context as to what other
elements are at play in your organization.
hth…
MJ
On Mar 17, 2020, at 9:28 AM, Sallie Cottingham <Sallie.Cottingham@xxxxxxxxxx>
wrote:
What are your thoughts/experiences with encryption?
We have one very old database that stores SSN in several tables (did I say it
is old and definitely not normalized?). The system is currently being
rewritten but in the meantime, we are looking to see Oracle options for
encryption. In your experiences how have you handled just one element
encryption or one element in several locations?
I’m also assuming this will require an additional license – is that correct?
Sallie Cottingham
Database Administrator
Comptroller of the Treasury
Technology Solutions
425 Fifth Avenue North
Nashville, TN 37243-34001
sallie.Cottingham@xxxxxxxxxx <mailto:sallie.Cottingham@xxxxxxxxxx>
615-401-7962
<image001.png>
<https://forms.office.com/Pages/ResponsePage.aspx?id=2LIbXg4PBUmsyXNR-FBv9vKJmJb3wIJGtlfwguW_b_tUOENWVkxEUUZOT0pHS00xSk1NVzZZSDBVRy4u>
