top of page

Check last user login

While performing database audits, you might need to check who logged in last into the database. The query will help you find out last user 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');

Related Posts

Heading 2

Add paragraph text. Click “Edit Text” to customize this theme across your site. You can update and reuse text themes.

bottom of page