Oracle DBA FAQ

Would you like to react to this message? Create an account in a few clicks or log in to continue.
Oracle DBA FAQ

Oracle RAC interview questions, Oracle Dataguard, ASM, CRS, Oracle wait events, Performance Tuning


    last login time for database users in oracle database 12c

    avatar
    Admin
    Admin


    Posts : 17
    Join date : 2010-02-08

    last login time for database users in oracle database 12c Empty last login time for database users in oracle database 12c

    Post  Admin Fri Aug 02, 2013 10:16 am

    The last login time for database users is recorded in the USER$ table and displayed when connecting to the database using Oracle SQL*Plus.

    Recording the last login time for database users increases database security by providing security administrators the ability to determine when an account was last used in the database. Displaying the last login time in the Oracle SQL*Plus connection banner provides the SQL*Plus user information on their last account usage.

      Current date/time is Fri Apr 19, 2024 8:57 am