Hi Joseph,
Thank you.
The dba team, which has couple of guys, have the pwd
for sys and schema owner and dba priv. I want to know
which one in the team did some unwanted "cleanning"
work, and also know who we should beat to death.
--- "Joseph S. Testa" <[EMAIL PROTECTED]> wrote:
> the answer is kinda/sorta.
>
> if auditing = true
> then
> if auditing for drops
> then
> yes youi can find out
> end if
> elsif you're on oracle 8 or 8i
> then
> use logminer and yes you can find out(i didnt say
> it was easy, as its
> not).
> end if
>
>
> if you need to know how to do it with logminer, let
> me know, I cover it
> in an advanced class on logminer, its some serious
> detective work but
> can be done.
>
> I have to ask though, who all has the object owner
> password, or did
> someone w/dba privilege do it?
>
> Joe
>
> Leslie Lu wrote:
> >
> > Hi all,
> >
> > Is there a way to find out who dropped an object
> and
> > when did that happen?
> >
> > Thank you.
> >
> > Leslie
> >
> >
>
>
> --
> Joe Testa http://www.oracle-dba.com
> Performing Remote DBA Services, need some backup DBA
> support?
> For Sale: Oracle-dba.com domain, its not going cheap
> but feel free to
> ask :)
> --
> Please see the official ORACLE-L FAQ:
> http://www.orafaq.com
> --
> Author: Joseph S. Testa
> INET: [EMAIL PROTECTED]
>
> Fat City Network Services -- (858) 538-5051 FAX:
> (858) 538-5051
> San Diego, California -- Public Internet
> access / Mailing Lists
>
--------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an
> E-Mail message
> to: [EMAIL PROTECTED] (note EXACT spelling of
> 'ListGuru') and in
> the message BODY, include a line containing: UNSUB
> ORACLE-L
> (or the name of mailing list you want to be removed
> from). You may
> also send the HELP command for other information
> (like subscribing).
__________________________________________________
Do You Yahoo!?
Get personalized email addresses from Yahoo! Mail - only $35
a year! http://personal.mail.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Leslie Lu
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
