Re: On 9i and 10g, When an Oracle User Last Accessed the Database?
From: John Hurley <johnbhurley_at_sbcglobal.net>
Date: Fri, 28 Aug 2009 10:09:36 -0700 (PDT)
Message-ID: <99d5839f-ee03-4894-aa04-55df542908cc_at_a26g2000yqn.googlegroups.com>
On Aug 28, 12:10 pm, "if_inves..._at_yahoo.com" <basis_consult..._at_hotmail.com> wrote:
Date: Fri, 28 Aug 2009 10:09:36 -0700 (PDT)
Message-ID: <99d5839f-ee03-4894-aa04-55df542908cc_at_a26g2000yqn.googlegroups.com>
On Aug 28, 12:10 pm, "if_inves..._at_yahoo.com" <basis_consult..._at_hotmail.com> wrote:
snip
> Hi,
>
> On Oracle 10g and 9i, is there a way to find out when a given user
> last accessed the
> database?
>
> Thanks,
> QZ
It depends on what level of auditing is in effect ( or not ) and/or special triggers have been created ( or not ).
Consult with the relevant oracle DBA's for your organization if you are a SAP basis consultant. Received on Fri Aug 28 2009 - 12:09:36 CDT