Path: news.easynews.com!newsfeed1.easynews.com!newsfeed2.easynews.com!easynews.com!easynews!newsfeed.news2me.com!newsfeed.icl.net!newsfeed.fjserv.net!feed.news.nacamar.de!newsfeed01.sul.t-online.de!t-online.de!lnewspeer01.lnd.ops.eu.uu.net!news01.triaton.com!dnewsfeed02.dtm.ops.eu.uu.net!dnewsifeed01.dtm.ops.eu.uu.net!lnewsifeed02.lnd.ops.eu.uu.net!lnewspost00.lnd.ops.eu.uu.net!emea.uu.net!not-for-mail From: "Niall Litchfield" Newsgroups: comp.databases.oracle.misc References: <7f966bc5.0302271025.705648c5@posting.google.com> <3E5E9031.85F4508A@exesolutions.com> <7f966bc5.0302280324.34d0bf36@posting.google.com> <3E5F8C8D.5ADEDF1@exesolutions.com> <3e5f9427$0$6302$ed9e5944@reading.news.pipex.net> <3E5F96AA.3B7EC881@exesolutions.com> <7f966bc5.0303030516.38391f6e@posting.google.com> Subject: Re: Generate a CRUD matrix Date: Mon, 3 Mar 2003 21:41:28 -0000 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1106 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106 Lines: 57 Message-ID: <3e63cc0e$0$3412$cc9e4d1f@news.dial.pipex.com> NNTP-Posting-Host: 1Cust156.tnt15.lnd1.gbr.da.uu.net X-Trace: 1046727694 news.dial.pipex.com 3412 62.188.6.156 X-Complaints-To: abuse@uk.uu.net Xref: newsfeed1.easynews.com comp.databases.oracle.misc:94311 X-Received-Date: Mon, 03 Mar 2003 14:44:55 MST (news.easynews.com) by session rather than by access would seem more appropriate for your needs sorry. -- Niall Litchfield Oracle DBA Audit Commission UK ***************************************** Please include version and platform and SQL where applicable It makes life easier and increases the likelihood of a good answer ****************************************** "David FitzGerald" wrote in message news:7f966bc5.0303030516.38391f6e@posting.google.com... > DA Morgan wrote in message news:<3E5F96AA.3B7EC881@exesolutions.com>... > s.com> wrote in message > > > I'd correct you if I thought you wrong ... but in this case I think different > > people have read the request to be asking different things. It appears the OP > > should repost and clarify. > > Sorry I wasn't as clear as I ought to have been -- I'm still very much > new to Oracle, and if I try to get too detailed, sometimes I just get > it plain wrong and confuse others even more!! > > > Or at least let us know who did the best job of guessing the intent. > > Niall Litchfield seems to have got pretty close, he said : > > "Correct me if I'm wrong but running a sql trace on the session and > then > TKPROF'ing it will give all the tables accessed during the session as > originally requested. This is not the same as auditing, but it doesn't > appear to be auditing that he is after." > > This sounds like what I am after. However, I've played around with > tkprof and it produces huge reports! Absolutely massive. I would > simply want something along the lines of listing which tables had > updates performed on them, and which tables had select's performed on > them. No details of which columns the selects were performed on, or > what was returned. > > Would I need to set a trigger on each table (Am I right in thinking a > trigger is something fired when the table is accessed?) and from this > write out to file that a particular action has been taken on this > table? > > Thanks for the continued help, > David.