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