Sybase Adaptive Server, Configuration Manual

Page: 124 / 150

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.