This discussion is archived
1 Reply Latest reply: Jan 18, 2013 6:50 AM by Paul Horth RSS

Sqlquery

RajeshKanna Newbie
Currently Being Moderated
Hi,

How to know the last login date&time of allusers exists in the database?

(Note: not only the users exist in current session)
  • 1. Re: Sqlquery
    Paul Horth Expert
    Currently Being Moderated
    RajeshKanna wrote:
    Hi,

    How to know the last login date&time of allusers exists in the database?

    (Note: not only the users exist in current session)
    You need to enable session auditing with the

    AUDIT SESSION

    command

    Make sure audit_trail init parameter is set to DB

    and then you can find the info out in DBA_AUDIT_SESSION.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points