Online Documentation for SQL Manager for DB2

Audit Policies

Audit policy is a non-schema object to define an auditing policy at the current server. The audit policy determines what categories are to be audited; it can then be applied to other database objects to determine how the use of those objects is to be audited. This object is available only for database server version 9.5 and higher.

Creating Audit Policies

To create a new audit policy:

• select the Database | New Object... main menu item;
• select Audit Policy in the Create New Object dialog;
• edit audit policy properties using the appropriate tabs of Audit Policy Editor.

Hint: To create a new audit policy, you can also right-click the Audit Policies node of the DB Explorer tree and select the New Audit Policy... context menu item.

Editing Audit Policies

To edit an existing audit policy:

• select the audit policy for editing in the DB Explorer tree (type the first letters of the audit policy name for quick search);
• right-click the object and select the Edit Audit Policy <audit policy_name>... context menu item, or simply double-click the audit policy;
• edit audit policy definition using the appropriate tabs of Audit Policy Editor.

Dropping Audit Policies

To drop a audit policy:

• select the audit policy to drop in the DB Explorer tree;
• right-click the object and select the Drop Audit Policy <audit policy_name>... context menu item;
• confirm dropping in the dialog window.

Note: If more convenient, you can also use the following shortcuts:

Ctrl+N to create a new audit policy;

Ctrl+O to edit the selected audit policy;

Shift+Del to drop the object from the database.