Re: Auditing Question
From: Jim Kennedy <kennedy-down_with_spammers_at_attbi.com>
Date: Fri, 06 Jun 2003 00:30:23 GMT
Message-ID: <zgRDa.846951$OV.801155_at_rwcrnsc54>
Date: Fri, 06 Jun 2003 00:30:23 GMT
Message-ID: <zgRDa.846951$OV.801155_at_rwcrnsc54>
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_at_attbi.com with family. Remove the negative part, keep the minus sign. You can figure it out. "DiggidyMack69" <DiggidyMack69_at_hotmail.com> wrote in message news:c86ce4f.0306050810.477ba5e1_at_posting.google.com...Received on Fri Jun 06 2003 - 02:30:23 CEST
> 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???