DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Auditing

  1. #1
    Join Date
    Jul 2001

    In our production database one package has been deleted.

    Here all it IT guys knows the Adminstrative password.

    can we find out the machine name of the user who has done this,the problem here is audit_trail is not enabled in init.ora

    pl help me


  2. #2
    Join Date
    Jul 2001



    If the query is still in the shared SQL you can at least get the module responsible and hope that you use different tools:

    select module from v$sql where sql_text like '%- your package name- %';

    I guess that the session is closed by now, otherwise you could query the v$sql and the v$session and joined by v$sql.hash_value = v$session.sql_hash_value.

    Unfourtunately it does not help if you put on trace and do a recovery because the session data is not stored in the redo log.

    I don't think you can get the info in any way, sorry


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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.