Re: Who did what when?
Date: 27 Nov 2001 18:10:33 GMT
Message-ID: <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!
In article <28848062.0111191701.58a07ed6_at_posting.google.com>, Luxspes
<luxspes_at_altavista.com> writes:
- Catherine Devlin
http://profiles.yahoo.com/arcticturtle
>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