ANKUSH THAVALI
- 07 Sep, 2023
- 0 Comments
- 31 Secs Read
Check last user login
Check last user login
While performing database audits, you might need to check who logged in last into the database. following query will help you to findout who logged in to database :
select username, timestamp, action_name from dba_audit_session where action_name='LOGON' and rownum<10 and username not in ('SYS','DBSNMP','DUMMY','SYSTEM','RMAN');