📋Steps in this guide1/1

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

oracle configurationintermediate

by OracleDba

12 views

Overview

Code/Command (click line numbers to comment):

1
2
3

select username, timestamp, action_name from dba_audit_session
where action_name='LOGON' and
rownum&lt;10 and username not in ('SYS','DBSNMP','DUMMY','SYSTEM','RMAN');

Comments (0)

Please to add comments

No comments yet. Be the first to comment!