Re: Who did what when?

From: Daniel <twinsxu_at_yahoo.com>
Date: 28 Nov 2001 13:16:13 -0800
Message-ID: <e0e46f5b.0111281316.2b580f88_at_posting.google.com>


Look at alert.log in your background dump directory file. It should contain all the information you need.

catherinedevlin_at_geek.com wrote in message news:<9u0kup$6f4$1_at_news.netmar.com>...
> Looks like you'll want to read the Auditing documentation.
> Chapter 26 in the 9i Database Administrator's Guide (not sure
> about 8i, but I don't think it's changed that
> much.)
>
> http://download-west.oracle.com/otndoc/oracle9i/901_doc/server.901/a90117/toc.h
> tm
>
> I don't know about the IP address part. The view DBA_AUDIT_SESSION
> contains columns like USERHOST and TERMINAL that look promising.
>
> Good luck!
> - Catherine Devlin
> http://profiles.yahoo.com/arcticturtle
>
>
> In article <28848062.0111191701.58a07ed6_at_posting.google.com>, Luxspes
> <luxspes_at_altavista.com> writes:
> >Hello everybody!
> >How can I know who did what and when in Oracle 8i
> >¿who created a table, index, sequence? (from which IP address)
> >¿when the table, index, sequence, record was created?
> >¿any one knows?
> >please help me!!!!
> >LUXSPES
>
>
> ----- Posted via NewsOne.Net: Free (anonymous) Usenet News via the Web -----
> http://newsone.net/ -- Free reading and anonymous posting to 60,000+ groups
> NewsOne.Net prohibits users from posting spam. If this or other posts
> made through NewsOne.Net violate posting guidelines, email abuse_at_newsone.net
Received on Wed Nov 28 2001 - 22:16:13 CET

Original text of this message