Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

The Import Sensitive Columns window allows you to import a list of sensitive columns from a .csv file to speed the process of configuring your sensitive column auditing. Note that the .csv file must have a row for each database you want to add for sensitive column auditing. The first row value must be the database name, the second value must be the table name followed by values for table's column names. If a row has only two values, first for database name and second for table name, all the columns will be selected for sensitive columns. A row with only one value is invalid and will be ignored. See the following examples:

Database1, Table1, Column1, Column2 (Valid Row)

Database2, Table2 (Valid Row)

Database3 (Invalid Row)

You can access this window from the Instance Details view by selecting Import Sensitive Columns from the drop-down list available below the Audited Databases section.

Importing Sensitive Columns from .CSV

To import a .csv file containing sensitive column search details:

  1. Click Browse to search for and then select the .csv file you want to import.
  2. Check the table columns you want to include as sensitive columns and uncheck those table columns you want to ignore.
  3. Click OK to import the file.

Scroll pdf ignore
SQL Compliance Manager monitor, audit and alert on SQL user activity and data changes.
Newtabfooter
aliasIDERA
urlhttp://www.idera.com
 | 
Newtabfooter
aliasProducts
urlhttps://www.idera.com/productssolutions/sqlserver
 
Newtabfooter
aliasPurchase
urlhttps://www.idera.com/buynow/onlinestore
 | 
Newtabfooter
aliasSupport
urlhttps://idera.secure.force.com/
 | 
Newtabfooter
aliasCommunity
urlhttp://community.idera.com
 
|
 
Newtabfooter
aliasResources
urlhttp://www.idera.com/resourcecentral
 | 
Newtabfooter
aliasAbout Us
urlhttp://www.idera.com/about/aboutus
 
Newtabfooter
aliasLegal
urlhttps://www.idera.com/legal/termsofuse

Scroll Pagebreak