oracle user last connection date
Solutions on MaxInterview for oracle user last connection date by the best coders in the world
{{#items}}
{{text}}
{{/items}} {{ctaText}}
{{#items}} {{/items}}
showing results for - "oracle user last connection date"
Merlin
17 May 2018
1SELECT max(TIMESTAMP), A.USERNAME
2FROM DBA_AUDIT_TRAIL A
3WHERE ACTION_NAME = 'LOGON'
4GROUP BY USERNAME
5ORDER BY 1 DESC;similar questions
oracle previous yearhow to check grants on a package in oracleoracle list usersoracle sequence last numberoracle table statistics last analyzedoracle last connectionoracle list dates without weekendsoracle sysdba connect as another userhow to check last gather stats on table in oracleoracle role useroracle create role privilegeoracle last day of monthoracle last connexionoracle job sessionoracle user tablesoracle list grants on packagecurrent year sql oraclehow to set all the time serveroutput on in oracle sql developeroracle user privilegesoracle last user logonoracle current session detailsoracle privileges userssql oracle take only last resultsoracle rolling backoracle current dateoracle session date formatoracle list user grants your answer for
you will get a confirmation link on this - you will have to click that for successful submission of your answer. we require this to keep the website free of spam, bots and unhelpful content
please ensure to add code which is syntactically corrent and executes properly
ask question on maxinterview
you will get a confirmation link on this - you will have to click that for successful submission of your question. we require this to keep the website free of spam, bots and unhelpful content
please be clear, to the point and respectful