Answers for "oracle last user logon"

SQL
0

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

Code answers related to "SQL"

Browse Popular Code Answers by Language