Re: Who did what when?

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