Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Location
    Athens, GREECE
    Posts
    8

    Unanswered: Tracing users' activity.

    Hello everyone, I want to be able to find out who did what and when into my ORACLE database (for example: which logon account executed "DELETE" statements on a specific table during yesterday). How do I do this? Any advice or hint will be appreciated.

    Regards,
    Panos Tsapralis.

  2. #2
    Join Date
    Jan 2004
    Location
    Scottsdale, AZ
    Posts
    106

    Angry

    use the search facility in this forum and search for auditing.
    "Take Control!
    Make The Choice!
    Accept The Consequences!
    Deal With The Results! "

  3. #3
    Join Date
    Jan 2004
    Location
    Singapore
    Posts
    89

    Thumbs up Re: Tracing users' activity.

    Originally posted by ptsapralis
    Hello everyone, I want to be able to find out who did what and when into my ORACLE database (for example: which logon account executed "DELETE" statements on a specific table during yesterday). How do I do this? Any advice or hint will be appreciated.

    Regards,
    Panos Tsapralis.
    \

    Make use of SYS.AUD$ table.
    Thanks and Regards,

    Praveen Pulikunnu

Posting Permissions

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