var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: How to log the users of my Server?
I'm looking for a way to log all the users that log into my Sybase ASE (126.96.36.199) during a certain period of time.
Most of all I'd like to know their ip-address, so I can see if anyone that is not authorised, but got hold of passwords anyway, tries to connect to the Sybase server.
You can use Login Trigger feature in conjunction sp_client_addr and knock off logins that you don't like.
spid hostname ipaddr
------ ---------- ---------------
24 WILLY-LAPTOP 188.8.131.52
(1 row affected)
Re: How to log the users of my Server?
Use the global audit option "login/logout" and query out from sysaudits table. Also do not forget to take care of housekeeping of audit databases.
The fire triggers only comes with ASE 12.0
Available since 11.9
Available since versions 10 : audit
exec sp_configure "audit logon success", true
exec sp_configure "audit logon failure", true
Last edited by fadace; 11-19-03 at 10:26.
Thanks all for replying. Now I have some tools to do the job right!