Results 1 to 4 of 4
  1. #1
    Join Date
    Oct 2003
    Posts
    28

    How to know USER WHICH DROPPED OBJECT

    Hi
    My question is can we know the user which dropped or truncate table , partitions or indexes ??

    How can we know it
    thanks 4 the reply

    sidnet

  2. #2
    Join Date
    Apr 2003
    Location
    Minneapolis, MN
    Posts
    273
    With the help of AUDIT feature.

    please look at here for more information...

    http://download-west.oracle.com/docs...udit.htm#10046

    HTH
    Bhavin

    MS Computer Science
    OCP DBA 9i/8i

  3. #3
    Join Date
    Jan 2004
    Location
    India
    Posts
    113
    Exactly Auditing is the feature which keeps you updated with operation on tables. If I remember it correctly AUD$ is the table from which we can find out the necessary info..
    Go through the documentation before using it.

    Cheers
    Kaushik

  4. #4
    Join Date
    Sep 2003
    Location
    Milan, Italy
    Posts
    130
    Also a DDL trigger may help (8i+ only)

    create or replace trigger ...
    after drop on schema ...

    Never used myself - but it may help you .

    hth
    al

Posting Permissions

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