1 Reply Latest reply on Jan 18, 2013 2:50 PM by Paul Horth

    Sqlquery

    RajeshKanna
      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
          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.
          1 person found this helpful