Audit for user login & logout of the Database
User01Sep 28 2011 — edited Oct 5 2011Hi,
I turned audit on todweb database for user logging (enabled audit users sessions). It writes a record when any user logs on and one record when logged off. Auditors might like to have information about which tool was used for connecting to database too. The standard audit_trail does not have that info. Please let me know how to display application/tool connecting to the database for that user session.
Below is the sample query (need to add with which PROGRAM,MODULE it is connecting to the below query).
select OS_USERNAME||'='||USERHOST||'='||ACTION_NAME||'='||TO_CHAR(timestamp,'DD-MON-YYYY HH24:MI:SS')||'='||TO_CHAR(logoff_time, 'DD-MON-YYYY HH24:MI:SS') from dba_audit_session;
Looks like dba_audit_session has SESSIONID - i checked this with SID of v$session. Both are different. Appreciate your reply.