Answers for "oracle last connection user"

SQL
1

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;
Posted by: Guest on April-14-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language