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.
To import a .csv file containing sensitive column search details:
SQL Compliance Manager monitor, audit and alert on SQL user activity and data changes.| | | | | | | |