Search
 
SCRIPT & CODE EXAMPLE
 
CODE EXAMPLE FOR SQL

oracle last connexion

SELECT a.USERNAME, max(TIMESTAMP) FROM DBA_AUDIT_TRAIL a
WHERE ACTION_NAME = 'LOGON' AND USERNAME IN ('MY_USER')
GROUP BY USERNAME ORDER BY 1;
 
PREVIOUS NEXT
Tagged: #oracle #connexion
ADD COMMENT
Topic
Name
6+1 =