Results 1 to 5 of 5
  1. #1
    Join Date
    Mar 2008
    Posts
    8

    Unanswered: how to check last login details of a user & transactions done by him

    hi friends can anybody tell how can i get information like who all user logged in and what all transactions they did previous day.and the time at which they did all enteries,updates.. etc...

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Enable AUDITING on your database.

  3. #3
    Join Date
    Mar 2008
    Posts
    8
    hi thanks for ur reply but could u please tell me how to do that as am new to this concept.and moreover if i enable it what exact output i lll get .i mean to ask will i get the infomation but the number of users logged in and what all they changed in my database along with time.

  4. #4
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    There are nice people working for Oracle corp. who write documentation in order to explain us, ordinary Oracle users, how to use features another nice people offered in different Oracle products.

    Auditing, as many other terms, are described in Oracle documentation. You may find it on http://tahiti.oracle.com.

  5. #5
    Join Date
    Mar 2008
    Posts
    8
    hi i got idea about auditing for refering this site : http://www.csee.umbc.edu/help/oracle...7772/audit.htm

Posting Permissions

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