Oracle DBA FAQ

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


    last login time for database users in 12c

    Share

    Admin
    Admin

    Posts : 17
    Join date : 2010-02-08

    last login time for database users in 12c

    Post  Admin on Fri Aug 02, 2013 9:37 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 Tue Apr 25, 2017 2:12 pm