current audit table

current audit table establishes the table where SAP ASE writes audit rows.

Summary Information
Default value	1
Range of values	0–8
Status	Dynamic
Display level	Intermediate
Required role	System security officer
Configuration group	Security Related

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 SAP ASE 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, SAP ASE 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 SAP ASE 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.

Note: If SAP ASE 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.