Avatar of Jan Franek
Jan Franek
Flag for Czechia asked on

Sybase IQ audit

Is it possible to log all user activity in Sybase IQ server (like Sybase ASE auditing) ?
Sybase Database

Avatar of undefined
Last Comment
gheist

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
gheist

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
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 ?
gheist

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.
Jan Franek

ASKER
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.
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck
gheist

congratulations and thank you for feedback.