Re: Last login date

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Fri, 21 Jul 2006 07:22:43 +0200
Message-ID: <i3p0c2tqannqit7pupedd0e2d72eo3g7q9@4ax.com>

On Thu, 20 Jul 2006 18:07:22 -0400, Evan Ehrenhalt <eehrenh_at_emory.edu> wrote:

>Hello,
>
>I have upgraded a database to Oracle 10.2 on RH3.
>
>Before we implement auditing or a login trigger (ie. past tense) can we
>determine:
>A) the last login date for each ID
>or
>B) If they have ever logged in
>
>I doubt it is possible, but I figure you guys are the experts.
>
>Thanks,
>
>Evan

Provided you did set the audit_trail parameter to dba, and you did issue the audit connect command, yes, you can. If you didn't do that, you are out of luck.

--
Sybrand Bakker, Senior Oracle DBA

Received on Fri Jul 21 2006 - 00:22:43 CDT