audit of sql-statements

Posted in 1999

Topics: Security, Permissions & Auditing

HIM Biebesheim — Mon, 1 Mar 1999 12:30:11 +0100 — source: Informix-list mailing list archive (1991-1998)

Hi, I want to use audit to watch a user. With the statement onauditshow I can see some of his actions, but I want to track all SQL-statements,for example select * from table or so. Either I also can only see the number of the table,- I want to get the table name.Who can help ? Thanks

↪ replying to HIM Biebesheim

Martin Berns — Tue, 02 Mar 1999 11:35:59 +0100 — source: Informix-list mailing list archive (1991-1998)

HIM Biebesheim wrote: > > Hi, > I want to use audit to watch a user. With the statement onauditshow I can > see some of his actions, but I want to track all SQL-statements,for example > select * from table or so. Either I also can only see the number of the > table,- I want to get the table name.> Who can help ? > Thanks Have a look at I-Spy, it's designed for Data Warehouses, but from what i read it will do exactly what you're asking; plus much more (e.g. generating explain-files) hth martin

↪ replying to Martin Berns

Randy Reiter — 3 Mar 1999 12:59:44 GMT — source: Informix-list mailing list archive (1991-1998)

Check out www.sqlpower.com The Sql Power SniFFFer is about to be released for Informix. It is a ZERO impact, 100% non-intrusive -- SQL service level monitor that will capture all SQL statements with their associated performance. The Sql Power SniFFFer product line non-intrusively reverse engineers the SQL network packet flow to the database server for SQL transaction performance monitoring. The product does NOT have to run on the database server, NOR on any client workstations connected to the database server. The Sql Power SniFFFer products require NO intrusive database server monitors, agents, probes, audits, middleware or proxy servers. . The Sql Power SniFFFer products have NO impact upon the database servers, network or end-users. It does not require a connection nor communication to an Informix database server or installation of agents on client workstations. Monitors 1000+ transactions/sec with ZERO impact upon the database server. Randy Reiter Sql Power Tools Martin Berns wrote in message <36DBBF0F.DE5F4AA8@Materna.De>... > > >HIM Biebesheim wrote: >> >> Hi, >> I want to use audit to watch a user. With the statement onauditshow I can >> see some of his actions, but I want to track all SQL-statements,for example >> select * from table or so. Either I also can only see the number of the >> table,- I want to get the table name.>> Who can help ? >> Thanks >Have a look at I-Spy, it's designed for Data Warehouses, but from what i >read >it will do exactly what you're asking; plus much more (e.g. generating >explain-files) >hth >martin