Database Activity Monitoring (DAM) policies : Data policies : Configuring a table and column policy
 
Configuring a table and column policy
For basic policy configuration information, see “Data policies”.
For information on setting rules for alert policies, see “Configuing alert rules for a table policy”.
To configure audit settings for a table and column policy
1. Click the triangle icon of the Audit Settings section to expand it.
2. 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).
3. If you are configuring the policy using Policy > DAM Alert/Audit Policies and selecting an object by browsing, for Target, select a target.
4. 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.
5. In the Tables list, select a table.
6. In the Column list, select one or more columns for the table you selected.
7. If you are configuring an alert policy, for MatchSQL, enter a SQL string that generates alerts when FortiDB detects it.
8. 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.
9. Click > (right arrow) to move your selection to the Selected Objects table.
 
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).
10. Repeat steps 5 through 9 to add additional columns to the Selected Objects table, if required.