current audit table

Summary information

Default value

1

Range of values

0–8

Status

Dynamic

Display level

Intermediate

Required role

System Security Officer

current audit table establishes the table where Adaptive Server writes audit rows. A System Security Officer can change the current audit table, using:

sp_configure "current audit table", n 
  [, "with truncate"]

where n is an integer that determines the new current audit table, as follows:

"with truncate" specifies that Adaptive Server should truncate the new table if it is not already empty. sp_configure fails if this option is not specified and the table is not empty.

NoteIf Adaptive Server truncates the current audit table, and you have not archived the data, the table’s audit records are lost. Be sure that the audit data is archived before using the with truncate option.

To execute sp_configure to change the current audit table, you must have the sso_role active. You can write a threshold procedure to change the current audit table automatically.