Sybase DC35823-01-1500-04 manual Logging auditing events, Managing messages, 108

Managing messages

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.

108 Adaptive Server Enterprise