Configuring multiple columns
The bulk edit option on Database View allows you to configure multiple columns at the same time. From the bulk editing panel, you can:
Mark the selected columns as sensitive or not sensitive.
Assign a generator to the selected columns.
Apply the recommended generator to the selected columns.
Reset the generator configuration to the baseline. Requires that all of the selected columns are assigned the same preset.
Depending on the column selection, you can also create a new sensitivity rule.
Displaying the bulk edit option
To select the columns and display the bulk edit option:
Check the checkbox next to each column to update.
Click Bulk Edit.
Marking the columns as sensitive or not sensitive
Required workspace permission: Configure column sensitivity
On the Bulk Edit panel, under Sensitivity:
To mark the selected columns as sensitive, click Sensitive.
To mark the selected columns as not sensitive, click Not Sensitive.
Changing the assigned generator
Required workspace permission: Configure column generators
On the Bulk Edit panel, under Bulk Edit Applied Generator, select and configure the generator to assign to the selected columns.
Assigning the recommended generator to the columns
Required workspace permission: Configure column generators
If any of the selected columns have a recommended generator, then on the Bulk Edit panel, the Generator recommendations found panel displays. The panel indicates the number of selected columns that have a recommendation.
To assign the recommended generators to those columns, click Apply.
Restoring the baseline configuration for the columns
Required workspace permission: Configure column generators
For a generator preset, the baseline configuration is the configuration that is saved for that preset. The baseline configuration determines the default configuration is used when you assign the preset to a column. After you select the preset, you can override the baseline configuration.
If all of the selected columns are assigned the same preset, then to restore the baseline configuration for all of the columns, click Reset to Baseline.
Creating a sensitivity rule
Required license: Enterprise
Required global permission: Create and manage sensitivity rules
You might bulk edit columns that could benefit from a custom sensitivity rule.
For example, in your data, the Widget column is in multiple tables and contains sensitive data that Structural cannot identify. You select all of the Widget columns so that you can mark them as sensitive and apply the Character Scramble generator to them. However, a custom sensitivity rule would ensure that in the future, Widget columns are always marked as sensitive and have the Character Scramble generator recommended.
On the Bulk Edit panel, when all of the selected columns:
Have the same data type
Do not have a generator assigned
Do not have a recommended generator
Then Structural displays the Create a Sensitivity Rule panel, which contains the option to create a new sensitivity rule.
To create a sensitivity rule:
Click Create Custom Rule.
When you finish configuring the new rule:
To both save the rule and immediately run a sensitivity scan, click Save and Scan.
To only save the rule, but not start a sensitivity scan, click Save.
Structural closes the sensitivity rule configuration view and returns you to Database View. It maintains the previous column selection.
Last updated
