Link to home
Start Free TrialLog in
Avatar of Jan Franek
Jan FranekFlag for Czechia

asked on

Sybase IQ audit

Is it possible to log all user activity in Sybase IQ server (like Sybase ASE auditing) ?
ASKER CERTIFIED SOLUTION
Avatar of gheist
gheist
Flag of Belgium image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Jan Franek

ASKER

Thanks for the hint, but it seems like it does not record procedure calls and ad-hoc user queries. Can these actions be audited too ?
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc74600.1270/html/iqrbaix/CIHGIBJC.htm

Some audit features are not available when it could hurt performance. Also given there is only few thousands of IQs around the world you should rely on Sybase documents, knowledge of ASE is just a shortcut there.
OK, I have found out, that auditing of procedure calls and ad-hoc queries is called request logging in Sybase IQ/SQL Anywhere. It can be switched on/off using command line options when starting the server (-zr -zs -zo) or using sa_server_option when the server is already running.
congratulations and thank you for feedback.