Reply-To: "Jim Kennedy" From: "Jim Kennedy" Newsgroups: comp.databases.oracle References: Subject: Re: Auditing Question Lines: 23 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2800.1158 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165 Message-ID: NNTP-Posting-Host: 12.224.116.189 X-Complaints-To: abuse@attbi.com X-Trace: rwcrnsc54 1054859423 12.224.116.189 (Fri, 06 Jun 2003 00:30:23 GMT) NNTP-Posting-Date: Fri, 06 Jun 2003 00:30:23 GMT Organization: AT&T Broadband Date: Fri, 06 Jun 2003 00:30:23 GMT There are not any hidden columns with last updated time for a row (unless they developed the application and did that). Use logminer. Jim -- Replace part of the email address: kennedy-down_with_spammers@attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "DiggidyMack69" wrote in message news:c86ce4f.0306050810.477ba5e1@posting.google.com... > Hello all, > I'm rather new to Oracle administration but I am wondering if there > are either hidden columns or system tables that are setup to catch > when an update has been made on various rows on certain tables. > > For instance I would like to find a certain ROWID and see when the > last time it was update and if possible by whom. > > I've been given certain developer priv's for my own schema but none of > the sys views or logminer stuff. Is there a way for me to get at this > info???