Managing the transaction log with no truncation  Single-table auditing

Chapter 18: Auditing

Enabling and disabling auditing

To enable or disable auditing, use sp_configure with the auditing configuration parameter. The syntax is:

sp_configure "auditing", [0 | 1 ]

For example, to enable auditing, enter:

sp_configure "auditing", 1

NoteWhen you enable or disable auditing, Adaptive Server automatically generates an audit record. See event codes 73 and 74 in Table 18-5.





Copyright © 2005. Sybase Inc. All rights reserved. Single-table auditing

View this book as PDF