2 Replies Latest reply: May 8, 2012 6:56 AM by 758358 RSS

    Query for Find user how delete object

    749917
      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
          ANy one have idea about this ..
          • 2. Re: Query for Find user how delete object
            758358
            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