Finding out the user who dropped a table
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 7 of 7

Thread: Finding out the user who dropped a table

  1. #1
    Join Date
    May 2000
    Location
    Marlboro, MA, US
    Posts
    1


    Hi,

    Is there any way we can find who dropped a table in a database with out having auditing enabled on the database. Does log miner show
    this information? or is there any third party tool which can be used to investigate who dropped the table.

    Any information is greatly appeciated.

    Thanks,
    Sreeni.

  2. #2
    Join Date
    Aug 2000
    Location
    Chicago IL
    Posts
    586

    Lightbulb

    doesnt alert log document that?
    "High Salaries = Happiness = Project Success."

  3. #3
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Check out http://www.dbasupport.com/forums/sho...?threadid=5933

    To prevent this in the future, look into system level triggers...
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  4. #4
    Join Date
    Apr 2000
    Location
    Edison, NJ
    Posts
    759
    Log Miner cannot undo DDL. It can only undo DML. You should consider revoking drop/truncate table from the users.

  5. #5
    Join Date
    Feb 2000
    Location
    New York,U.S.A.
    Posts
    245
    I encountered same problem not long ago. I think the best I can do now is to create a trigger on drop the database, By doing that you will find out who and when dropped the table and start from here to track down the user do did drop. Then I create another trigger on certain important tables to monitor the DMLs done on those tables. I am still searching for the better alternative.

    Dragon

  6. #6
    Join Date
    Apr 2001
    Location
    Louisville KY
    Posts
    295
    I have not used it, but the 'data mining' function of RMAN in 8.1.6 and later is supposed to be able to recreate the transactions up to a point in time so the dba can generate corrective scripts, etc. You may be able to use this to identify the user.
    Joseph R.P. Maloney, CSP,CDP,CCP
    'The answer is 42'

  7. #7
    Join Date
    Oct 2000
    Location
    Saskatoon, SK, Canada
    Posts
    3,925
    Check this link, It might help you.

    http://www.dbasupport.com/forums/sho...?threadid=7595



    Sam
    Thanx
    Sam



    Life is a journey, not a destination!


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width