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

Thread: user details

  1. #1
    Join Date
    Dec 2000
    Posts
    255
    Hello

    I would like to know whether I can see history of users logged in in oracle for a past few days. Currently our oracle has installed at remote server and I am accessing it using database links from my local oracle. If I want to who has logged on 2 days back and for what time how can I know it. Which system table contains this information.

    Amol

  2. #2
    Join Date
    Aug 2000
    Location
    Belgium
    Posts
    342
    You have to enable auditing to do this.

    Regards
    Gert

  3. #3
    Join Date
    Sep 2000
    Posts
    384
    If you are using 8i inform .

    database event triggers can be used for the same.
    It is quite easy and maintence free...

    pls inform if you have any troubles..
    Radhakrishnan.M

  4. #4
    Join Date
    Oct 2000
    Location
    Dallas:TX:USA
    Posts
    407
    If you haven't implemented any of the procedures mentioned above then you may want to look into the Listener log file that keeps information of all the connections.

    This file could be found in oracle_home\network\log on the database server.

    - Rajeev


  5. #5
    Join Date
    Dec 2000
    Posts
    255
    Hi

    Can you tell me how to enable auditing option
    and also i am using Oracle 8i

    Amol

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