Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I am struggling to get way to log user connection access,queries that are fired to database(SYBASE IQ 15.2).

I tried request level logging but it has great performance impact.

Is there any way ,script that will ONLY monitor user id ,ip,query,time that user has fired?

Again is there any provision to monitor only some tables?

share|improve this question

You could try the Auditing in Sybase IQ:

You could also follow activity of individual login my running a stored procedure at login.
For instance:

sp_modifylogin my_login, "login script", my_proc

where my_proc =

create proc my_proc
as <code>
share|improve this answer
HI I tried this already.But it has huge performance impact.Here in my system I want to audit ONLY few tables where i want to track user id,ip,time,query more info needed as other info puts extra overhead on system.Can we write any script,proc in oredr to achieve this? – user29710 Oct 23 '13 at 13:09

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.