Creating a database for audit data

About this task

To load data files into a database with dbload, a database to receive the data must already exist.

Procedure

Create a database to hold copies of audit records with the CREATE DATABASE statement.

By default, the CREATE DATABASE statement creates the database with privileges that allow access only to the owner, which is the appropriate security measure. It is not necessary to use logging within a database created strictly for audit analysis because the data must not be modified.

The following statement creates a database called auditlogs97:

CREATE DATABASE auditlogs97

You can also create an ANSI-compliant database. Although an ANSI-compliant database has the additional overhead of logging, its treatment of table permissions or access privileges makes it attractive in a secure environment. For more information about UNIX™ permissions or Windows™ access privileges, see Revoking and granting privileges to protect audit data.

The following SQL statement creates an ANSI-compliant database:

CREATE DATABASE auditlogs97 WITH LOG MODE ANSI