1 Reply Latest reply: Jan 18, 2013 8:50 AM by Paul Horth RSS

    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.