May 13, 2019 5:03:00 PM by Julie Hyman
Toad for Oracle Sensitive Data Protection Module is a new module available for Toad for Oracle users. This new module contains two areas of functionality – Sensitive Data Protection Awareness and Sensitive Data Protection Search – which enable developers and DBAs to work effectively with the sensitive data in their environment.
The Sensitive Data Awareness features in the Toad for Oracle Professional edition alert developers of data columns that may contain sensitive data as they write code in the Editor or as they create and alter tables. The developers can quickly get information on these columns – including what kind of sensitive data they may contain and what protective measures are in place for that column (audit, redaction and encryption policies) through a simple mouse over.
Once the field is identified in the Editor, users with the correct database privileges can also r-mouse click on the field to add protection to this field – like encrypting this column.
Users will also see an indicator (orange “dot”) in alter and create table windows flagging column names that may contain sensitive data (based on column naming patterns).
The Sensitive Data Protection Search capabilities allow users to scan schemas – looking at both patterns in columns naming conventions as well as polling actual data to identify columns that may contain sensitive data. Once these columns are discovered, the user can do a deeper dive to understand what protection policies are in place for these columns (audit, redaction and encryption) and, if needed, add new policies to these columns on the fly.
Users can define what “Sensitive Data” means to them by customizing the pre-loaded Sensitive Data patterns (both for column naming and data contents) in the View > Toad Options > Sensitive Data Protection area.
Toad for Oracle Sensitive Data Protection Module features were released in Toad for Oracle v13.1 and v13.1.1. The Sensitive Data Awareness features are part of Toad for Oracle Professional Edition (or above). The Sensitive Data Protection Search features require an additional purchase in addition to owning Toad for Oracle Professional addition (or above). For more information on how to activate the product or the trial - go here.
Tags: Toad for Oracle Development Administration FAQ Sensitive Data Protection
Written by Julie Hyman
Julie Hyman is a Sr. Product Manager for Quest Software. Julie has 20+ years of experience in Development, Project Management and Product Management.