1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Last Logon time of all users in an Oracle database

Discussion in 'General' started by abjcrawford, Oct 15, 2010.

  1. abjcrawford

    abjcrawford Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    :)Hi Folks

    I want to find out the last logon time of all users registered in the database , this is required for user auditing purpose.

    I am currently using
    select username,to_char(logon_time,'DD:MM:YYYY') from v$session

    This is gives me a list of all users currently logged in.

    Any help in this query would be greatly appreciated.

    I am new to this thread. Please direct me to the right group if this is not where I am supposed to post this question.

    Thanks in advance
     
  2. zargon

    zargon Community Moderator Forum Guru

    Messages:
    2,347
    Likes Received:
    348
    Trophy Points:
    1,430
    Location:
    Aurora, CO
    Read here:

    http://oratips-ddf.blogspot.com/2006/05/audit-this.html
     
  3. abjcrawford

    abjcrawford Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Thanks David.
    I will read through it and see if I can apply it .