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?Desperately needed.
You could try the Auditing in Sybase IQ:
You could also follow activity of individual login my running a stored procedure at login.
where my_proc =