# Oracle Database Last Logins with Oracle 12c

- URL: https://www.integrigy.com/oracle-security-blog/oracle-database-last-logins-oracle-12c
- Published: 2014-11-10
- Type: Blog Post
- Products: Oracle Database
- Focus areas: Auditing

Tracking when database users last logged in is a common security and compliance requirement – for example to reconcile users and identify stale users. With Oracle 12c this analysis can now be done through standard functionality. New with Oracle12c, the SYS.DBA_USERS has a new column: last_login.

select username, account_status, common, last_login

from sys.dba_users

order by last_login asc;

| **Username**        | **Account_Status** | **Common** | **Last_Login**                                   |
| ------------------- | ------------------ | ---------- | ------------------------------------------------ |
| C##INTEGRIGY        | OPEN               | YES        | 05-AUG-14 12.46.52.000000000 PM AMERICA/NEW_YORK |
| C##INTEGRIGY_TEST_2 | OPEN               | YES        | 02-SEP-14 12.29.04.000000000 PM AMERICA/NEW_YORK |
| XS$NULL             | EXPIRED & LOCKED   | YES        | 02-SEP-14 12.35.56.000000000 PM AMERICA/NEW_YORK |
| SYSTEM              | OPEN               | YES        | 04-SEP-14 05.03.53.000000000 PM AMERICA/NEW_YORK |

If you have questions, please contact us at <mailto:info@integrigy.com>

## Reference

- Integrigy Oracle 12c Unified Auditing Whitepaper [Oracle 12c Unified Auditing](https://www.integrigy.com/security-resources/oracle-12c-unified-auditing)
