Re: finding PII data in an Oracle schema

Hi John

I'd second Neil's recommendation of dbsat. It's a tool that's well worth running (the latest version of) periodically, perhaps as a part or ahead of an internal audit.

As this is a verification exercise and you might have other database platforms in use on your org, many of the backup vendors now have support for identifying PII or Sensitive data - I know that Rubrik and Commvault have capabilities in this space and I expect many others do as well since the regulations you refer to also require proper backup security. I'd definitely approach your backup vendor to see what they offer.

On Wed, 21 Dec 2022, 18:32 Jon Crisler, <joncrisler_at_gmail.com> wrote:

> Has anybody run into any toolkits that can identify PII data in a schema ?
> I am looking to track down columns and tables in a user schema. I am not
> licensed for Oracle Data Masking so it has to be outside of that product,
> and preferably free. We are implementing other packages to do things
> like GDPR and California privacy laws, and I want to be able to validate
> via another source that no data structures were missed.
>

--
http://www.freelists.org/webpage/oracle-l