SQL query to retrieve users last login date in oracle

SQL query to retrieve users last login date in oracle

In this post , We will be discuss about sql query to find last login date oracle. Using this sql query , we will be able to find that , when the users have last login the oracle database and the oracle application. There are different sql query to find last login date for both oracle and application. To find out the Database last login date we need to refer the dba_users table in oracle. Here below is the detail about sql query to find last login date oracle.

SQL query to retrieve users last login date in oracle

2 Important sql query to  retrieve users last login date in oracle

To find the last login date for Oracle Database users , we need to refer this below sql query.

select

   username,

   last_login

from

   dba_users

order by

   username';

To find the last login date for Oracle Application users , we need to refer this below sql query.

select

   username,

   last_login_date

from

   fnd_user

order by

   username';