oracle user last connected
SELECT max(TIMESTAMP), A.USERNAME
FROM DBA_AUDIT_TRAIL A
WHERE ACTION_NAME = 'LOGON'
GROUP BY USERNAME
ORDER BY 1 DESC;
Are there any code examples left?
New code examples in category SQL
SELECT max(TIMESTAMP), A.USERNAME
FROM DBA_AUDIT_TRAIL A
WHERE ACTION_NAME = 'LOGON'
GROUP BY USERNAME
ORDER BY 1 DESC;