This discussion is archived
2 Replies Latest reply: May 7, 2012 11:56 PM by 758358 RSS

Query for Find user how delete object

749917 Newbie
Currently Being Moderated
I want find a user how drop a object from oracle 11g database.when i Check in through recycle-bin . I can find only dropped objects and its tablespaces .

I want to find out which person drop object and its O.S name .
  • 1. Re: Query for Find user how delete object
    749917 Newbie
    Currently Being Moderated
    ANy one have idea about this ..
  • 2. Re: Query for Find user how delete object
    758358 Pro
    Currently Being Moderated
    Hi,

    First off this isn't really the correct forum - for this question, you would have been answered much more quickly in the Database General forum.

    You have a few choices for this:

    1. Enable auditing (guessing you don't already have this), have a look at http://docs.oracle.com/cd/E11882_01/network.112/e16543/auditing.htm#DBSEG376
    or http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams083.htm#REFRN10302

    2. Setup a DDL trigger to log auditing in a customized way, have a look at http://docs.oracle.com/cd/E11882_01/appdev.112/e25519/triggers.htm#CIHEFBJA

    Thanks
    Paul

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points