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:
1 means sysaudits_01, 2 means sysaudits_02, and so forth, up to 8.
0 tells Adaptive Server to set the current audit table to the next table. For example, if your installation has three audit tables, sysaudits_01, sysaudits_02, and sysaudits_03, Adaptive Server sets the current audit table to:
2 if the current audit table is sysaudits_01
3 if the current audit table is sysaudits_02
1 if the current audit table is sysaudits_03
"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.
If 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.
