Xref: alice comp.databases.oracle.server:39571 Path: alice!news-feed.fnsi.net!news.idt.net!newshub.northeast.verio.net!newsfeed.wli.net!su-news-hub1.bbnplanet.com!su-news-feed1.bbnplanet.com!news.gtei.net!inet16.us.oracle.com!not-for-mail From: Peter Sharman Newsgroups: comp.databases.oracle.server Subject: Re: Any log for object being dropped Date: Tue, 02 Feb 1999 09:05:30 -0800 Organization: Oracle Corporation Lines: 46 Message-ID: <36B7305A.707CD985@us.oracle.com> References: <01be4e44$4a30b000$11899cd1@schen> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Mailer: Mozilla 4.5 [en] (WinNT; U) X-Accept-Language: en Steve It's logged in the redo logs, which you can look at with LogMiner in 8i, or possibly SQL*BackTrack (I don't know enough about this product - anyone else able to confirm?). More importantly, I'd look at the privileges you've given people, and take away the dangerous ones. Shutting the stable gate after the horse has bolted is of little use! HTH Pete Steve wrote: > Hi, > > Is there any log for object being dropped, such as table or index? The > alert log would not record this activity. The problem is somebody > dropped the object unexpectly but denied it. This is too dangarous. > > Thanks. > > Steve -- Regards Pete ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Peter Sharman Email: psharman@us.oracle.com WISE Course Development Manager Phone: +1.650.607.0109 (int'l) Worldwide Internal Services Education (650)607 0109 (local) San Francisco "Controlling application developers is like herding cats." Kevin Loney, ORACLE DBA Handbook "Oh no it's not! It's much harder than that!" Bruce Pihlamae, long term ORACLE DBA ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~