Configuring a table and column policy
For basic policy configuration information, see Data policies.
For information on setting rules for alert policies, see Configuring alert rules for a table policy.
To configure audit settings for a table and column policy
- Click the triangle icon of the Audit Settings section to expand it.
- Select one of the following options:
- Manually Select Object: You enter the object parameters.
- Browse Object by Target: You can select an object from the dropdown list (default).
- If you are configuring the policy using Policy > DAM Alert/Audit Policies and selecting an object by browsing, for Target, select a target.
- Do one of the following:
- For policies for Oracle and DB2 databases, for Schema, enter a schema name or select a name from the list.
- For policies for Microsoft SQL Server and Sybase databases, for Database, enter a database name or select a name from the list. Then, for Schema, enter a schema name or select a name from the list.
- In the Tables list, select a table.
- In the Column list, select one or more columns for the table you selected.
- If you are configuring an alert policy, for MatchSQL, enter a SQL string that generates alerts when FortiDB detects it.
- Under Audit Actions, do one of the following:
- For an alert policy, select the Read (Select), Write (Insert/Update/Delete), or both.
- For an audit policy, select one or more of the following options: Select, Insert, Update, Delete, Truncate.
- Click > (right arrow) to move your selection to the Selected Objects table.
- Repeat steps 5 through 9 to add additional columns to the Selected Objects table, if required.
For Oracle databases, you can also select a synonym.
|
If you want to remove the objects from the Selected Objects list, select the object you want to remove and then click < (left arrow). To remove all objects, click << (double left arrow). |