Use sp_configure parameters to specify
whether SAP ASE writes auditing events, such as logins, to the SAP ASE error
log.
By default, SAP ASE does not log auditing events. To log events, you can use
sp_configure with these possible
parameters and values:
-
log audit logon
success at 1 – to enable logging of
successful SAP ASE logins:
sp_configure "log audit logon success", 1
-
log audit logon
failure at 1 – to enable logging of
unsuccessful SAP ASE 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
See the System Administration Guide: Volume 1.