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;
|
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
