New system procedures

Use the system procedures listed in Table 5-2 to manage the auditing process.

**Table 5-2: New system procedures for auditing**
System Procedure	Description
sp_addauditrecord	Adds user-defined audit records (comments) into the audit trail. Users can add these records only if a System Security Officer enables ad hoc auditing with sp_audit.
sp_audit	Enables and disables all auditing options. This is the only system procedure required to establish the events to be audited.
sp_configure
"auditing"	Enables or disables auditing for Adaptive Server. The parameter takes effect immediately upon execution of sp_configure. Auditing occurs only when this parameter is enabled.
"audit queue size"	Establishes the size of the audit queue. Because this parameter affects memory allocation, it does not take effect until Adaptive Server is restarted.
"current audit table"	Sets the current audit table. This takes effect immediately upon execution of sp_configure.
"suspend auditing when full"	Controls the behavior of the audit process when an audit device becomes full. This takes effect immediately upon execution of sp_configure.
sp_displayaudit	Displays the active auditing options.

Table 5-2: New system procedures for auditing

System Procedure

Description

sp_addauditrecord

Adds user-defined audit records (comments) into the audit trail. Users can add these records only if a System Security Officer enables ad hoc auditing with sp_audit.

sp_audit

Enables and disables all auditing options. This is the only system procedure required to establish the events to be audited.

sp_configure

"auditing"

Enables or disables auditing for Adaptive Server. The parameter takes effect immediately upon execution of sp_configure. Auditing occurs only when this parameter is enabled.

"audit queue size"

Establishes the size of the audit queue. Because this parameter affects memory allocation, it does not take effect until Adaptive Server is restarted.

"current audit table"

Sets the current audit table. This takes effect immediately upon execution of sp_configure.

"suspend auditing when full"

Controls the behavior of the audit process when an audit device becomes full. This takes effect immediately upon execution of sp_configure.

sp_displayaudit

Displays the active auditing options.

The system procedures sp_auditoption, sp_auditdatabase, sp_auditobject, sp_auditsproc, and sp_auditlogin are obsolete. Use sp_audit for setting the options that you set with those system procedures in pre-11.5 releases.

Table 5-3 shows the system procedures that were used to set auditing options in pre-11.5 releases and the types of auditing options that replace them in Adaptive Server release 11.5. The auditing options in the groups mentioned in the second column of Table 5-3 are described in the discussion of sp_audit in the Adaptive Server Reference Manual.

**Table 5-3: Comparison of pre-11.5 and 11.5 options**
Option set in pre-11.5 releases	Option to set In 11.5
sp_auditoption	“global” auditing options
sp_auditdatabase	“database-specific” auditing options
sp_auditobject	“object-specific” auditing options
sp_auditsproc	“exec” auditing options
sp_auditlogin	“user-specific” auditing options

Table 5-3: Comparison of pre-11.5 and 11.5 options

Option set in pre-11.5 releases

Option to set In 11.5

sp_auditoption

“global” auditing options

sp_auditdatabase

“database-specific” auditing options

sp_auditobject

“object-specific” auditing options

sp_auditsproc

“exec” auditing options

sp_auditlogin

“user-specific” auditing options

For example, in pre-11.5 releases, you used the following command to audit the actions of deleting, updating and inserting information in the authors table of the pubs2 database:

sp_auditobject "authors", "pubs2", "both", "dui"

In release 11.5, these actions are covered by the delete, update, and insert options in the “object-specific” group. You use the following commands to achieve the same results as you did using the preceding, obsolete commands:

sp_audit "delete", "all", "authors", "on" sp_audit "update", "all", "authors", "on" sp_audit "insert", "all", "authors", "on"

To install auditing, see the Adaptive Server configuration guide for your platform. For more information about auditing, see Chapter 8, “Auditing,” in the Security Administration Guide.