Home » RDBMS Server » Security » how to retrieve user logging 120 days ago (RDMS oracle 12C linux)
how to retrieve user logging 120 days ago [message #686493] Tue, 27 September 2022 09:17 Go to next message
evoradba
Messages: 144
Registered: April 2005
Location: Canada
Senior Member
Hello

how do I see oracle 12c user activity 120 days ago? im looking for a select statment showing users login to the database more then 120 days ago, is this possible?



SELECT c.username,

a.SAMPLE_TIME,

a.SQL_EXEC_START,

b.SQL_TEXT

FROM DBA_HIST_ACTIVE_SESS_HISTORY a, dba_hist_sqltext b, dba_users c

WHERE a.SQL_ID = b.SQL_ID(+)

AND a.user_id = c.user_id

AND c.username = 'USERNAME'

ORDER BY a.SQL_EXEC_START ASC
Re: how to retrieve user logging 120 days ago [message #686494 is a reply to message #686493] Tue, 27 September 2022 13:10 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Query DBA_AUDIT_TRAIL.
Previous Topic: ORA-01017: invalid username/password
Next Topic: USB security token login
Goto Forum:
  


Current Time: Thu Mar 28 06:12:03 CDT 2024