Re: Usage Statistics

} } > Jack Parker write:- } > Pholks, } > > Can any one talk to me about this topic? How do you tell what data is } > usedby who and how frequently? } > > cheers } > j. } The only way that I can think of doing this is to build it into all } applications. It would slow them down and wouldn't detect SQL users, } etc. The way to do it would be to record each time a user activates a } particular 4GL program, subsystem, etc. This would then tell you which } tables were being accessed and using the USER function in SQL you could } tell who. } Malcolm Weallans } Online Database Consultancy } Problem is that I don't have any control over the tools which will be used. Is it possible (from a trigger-neophyte) to invoke a trigger on a SELECT? Is usage statistics a feature of any SQL engine known to this group? j. _____________________________________________________________________________ Jack Parker | Hewlett Packard, BSMC Boise, Idaho, USA| Every DOS PC should run Windows, jparker@hpbs3645.boi.hp.com | It gives them something to do. _____________________________________________________________________________ Any opinions expressed herein are my own and not those of my employers. _____________________________________________________________________________