oracle last user logon code example
Example: oracle last user logon
SELECT USERNAME, max(TIMESTAMP) FROM DBA_AUDIT_TRAIL
WHERE ACTION_NAME = 'LOGON' AND USERNAME = 'MY_USER'
GROUP BY USERNAME ORDER BY 1;
SELECT USERNAME, max(TIMESTAMP) FROM DBA_AUDIT_TRAIL
WHERE ACTION_NAME = 'LOGON' AND USERNAME = 'MY_USER'
GROUP BY USERNAME ORDER BY 1;