-
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;
inosov
Brainbench MVP for Oracle DBA
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|