Adaptive Server includes a comprehensive auditing system. The auditing system consists of:
The sybsecurity database
Configuration parameters for managing auditing
sp_audit to set all auditing options
sp_addauditrecord to add user-defined records to the audit trail
When you install auditing, you can specify the number of audit tables that Adaptive Server uses for the audit trail. If you use two or more tables to store the audit trail, you can set up a smoothly running audit system with no manual intervention and no loss of records.
A system security officer manages the audit system and is the only user who can start and stop auditing, set up auditing options, and process the audit data. As a system security officer, you can establish auditing for events such as:
Server-wide, security-relevant events
Creating, dropping, and modifying database objects
All actions by a particular user or all actions by users with a particular role active
Granting or revoking database access
Importing or exporting data
Logins and logouts
All actions related to encryption keys
Auditing functionality is discussed in Chapter 18, “Auditing.”
