User last logged in time / user login audit
Oracle database Enterprise Edition 19.18 on Oracle Liunx 7
RAC= 4 nodes
I am trying to figure out when certain users last logged in . We have an automated process (cyberark) that changes password everyday, so last login changes everyday.
select USERNAME,LAST_LOGIN,PASSWORD_CHANGE_DATE from dba_users where username in('LHARRIS')
USERNAME LAST_LOGIN PASSWORD_CHANGE_DATE
CHARRIS 7/19/2023 9:08 7/19/2023 9:08:34 PM
Question 1. Which table should I query to find last login for some users(employee users) ?
Question 2. how could create a simple audit to login some users' log in and log out timing? Examples would be appreciated.