Filter
Top Products
Managing messages
108 Adaptive Server Enterprise
Logging auditing events
By default, Adaptive Server does not log auditing events. However, you can
use
sp_configure parameters to specify whether Adaptive Server is to log
auditing events, such as logins, to the Adaptive Server error log.
Possible parameters and values are:
•
log audit logon success at 1 – to enable logging of successful Adaptive
Server logins:
sp_configure "log audit logon success", 1
• log audit logon failure at 1 – to enable logging of unsuccessful Adaptive
Server logins:
sp_configure "log audit logon failure", 1
• Either parameter at 0 – to disable logging of that message type:
sp_configure "log audit logon success", 0
sp_configure "log audit logon failure", 0
For more information about sp_configure, see the System Administration
Guide.