Database - RAC/Scalability (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center