Connection

[DavidShirazi]

Hi,
How can I know when was the last connection to the user Oracle account ?

I need it for cleaning old accounts on a development instance.

Thanks,
David

[jdorlon]

If you are using 8i, make a system trigger which fires on the LOGON event. You can make your trigger write the USER ID to a table.

There is no way that I know of to look into the past to see who
has logged on, unless you want to look through your SQLNet trace files (if tracing is turned on, that is)

-John

[inosov]

Use auditing. To setup it, set AUDIT_TRAIL=DB in init.ora,
restart database and run command "AUDIT SESSION" as DBA.

Logon information can be retrieved by the following query:

SELECT username, timestamp, logoff_time FROM sys.dba_audit_session;