[Info-Ingres] Can I count the number of hits (selects) on a table?

[Jean-Pierre Zuate]

Hello,

Try security audit and enable table event auditing ...

1/ Install, configure and turn security audit to on
2/ recycle ingres
3/ make sure all your tables are created with with_clause
security_audit(table) (or recreate them)
4/ enable security audit at table level : echo "enable security_audit
table\g" | sql iidbdb
5/ check regulary the iiaudit table (in iidbdb) to count the number of
select (or insert, update, delete), by table, user, db, whatever you want.

Note if you want to follow the row, your table must be createdb with
with_clause security_audit(table, row), security_audit_key(
your_column_unique) and enable row events with : echo "enable security_audit
row\g" | sql iidbdb

Hope this help,
Jean-Pierre
18 Apr 2007 08:22:13 -0700, jeffrey.duffy at gro-scotland.gsi.gov.uk <
jeffrey.duffy at gro-scotland.gsi.gov.uk>:
>
> Hi Guys
> Simple question however I think the answer might a bit trickier?
> I want to count the number of times a tables has a select performed on
> it.
> Any ideas appreciated.
>
> Havent been on here for a while but its good to see I can still get my
> viagra cheap. Not that I need them cheap with all my lottery
> winnings !!!
>
> Thanks
>
> Jeff
>
> _______________________________________________
> Info-Ingres mailing list
> Info-Ingres at kettleriverconsulting.com
> http://www.kettleriverconsulting.com/mailman/listinfo/info-ingres
>



-- 
Jean-Pierre Zuate
La Fage Conseil
+33(0)6 11 40 11 09
jpzuate at gmail.com
http://www.ingres-ua.fr/sponsors/la-fage-conseil/
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.kettleriverconsulting.com/mailman/private/info-ingres/attachments/20070418/e04e6692/attachment.html