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.
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)
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;
Brainbench MVP for Oracle DBA
Click Here to Expand Forum to Full Width