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
Printable View
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
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
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;