Skip to main content

Blog Post

Oracle Database Last Logins with Oracle 12c

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;

UsernameAccount_StatusCommonLast_Login
C##INTEGRIGYOPENYES05-AUG-14 12.46.52.000000000 PM AMERICA/NEW_YORK
C##INTEGRIGY_TEST_2OPENYES02-SEP-14 12.29.04.000000000 PM AMERICA/NEW_YORK
XS$NULLEXPIRED & LOCKEDYES02-SEP-14 12.35.56.000000000 PM AMERICA/NEW_YORK
SYSTEMOPENYES04-SEP-14 05.03.53.000000000 PM AMERICA/NEW_YORK

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

Reference