Take the 2-minute tour ×
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. It's 100% free, no registration required.

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.

share|improve this question

1 Answer 1

You could try the Auditing in Sybase IQ:
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc74600.1270/html/iqrbaix/CIHGIBJC.htm http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc00801.1520/html/iqrefso/CIHICIGJ.htm

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>
go
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 ONLY.no 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

 
discard

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.