Connection
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Connection

  1. #1
    Join Date
    Apr 2001
    Posts
    2

    Question

    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

  2. #2
    Join Date
    Nov 2000
    Posts
    344
    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

  3. #3
    Join Date
    Apr 2001
    Posts
    37
    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
  •  



Click Here to Expand Forum to Full Width