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

Thread: Identifying Last Logon

  1. #1
    Join Date
    Mar 2002
    Posts
    301

    Identifying Last Logon

    Hi,

    Basically our application uses Forms Runtime to connect with the production database. It uses OS authentication in order to connect with the db.

    Is there any way through which we can find out the last logon time of a user (we've not enabled any tracing)?

    Any help will be highly appreciated.

    Thanks.
    Vijay.
    Say No To Plastics

  2. #2
    Join Date
    Feb 2001
    Location
    UAE
    Posts
    304
    Why dont you use database event triggers such as after logon or before logoff?
    Agasimani
    OCP(10g/9i/8i/8)

  3. #3
    Join Date
    Jan 2002
    Location
    India
    Posts
    105
    That is good solution but which version of Oracle Database is ORAVIJAY is using ?
    I think Logon triggers will not be supported prior version of Oracle 8i

    Regards
    Viraj
    -----------
    OCP 9i DBA
    A Wise Man Knows How much he doesn't know !!!

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