niXforums Forum Index
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   PreferencesPreferences   Log in to check your private messagesLog in to check your private messages   Log inLog in 
·  nixdoc.net ·  man pages ·  Linux HOWTOs ·  FreeBSD Tips ·  Forums
navigation Forum index » Databases » Oracle » Server
Last login date
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
Author Message
Evan Ehrenhalt
*nix forums beginner


Joined: 20 Jul 2006
Posts: 1

PostPosted: Thu Jul 20, 2006 10:07 pm    Post subject: Last login date Reply with quote
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
Back to top
Sybrand Bakker
*nix forums Guru


Joined: 03 Apr 2005
Posts: 1766

PostPosted: Fri Jul 21, 2006 5:22 am    Post subject: Re: Last login date Reply with quote
On Thu, 20 Jul 2006 18:07:22 -0400, Evan Ehrenhalt <eehrenh@emory.edu>
wrote:

Quote:
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
Back to top
Google
Back to top
Display posts from previous:   
Post new topic   Reply to topic Page 1 of 1 [2 Posts] View previous topic :: View next topic
The time now is Sun Nov 23, 2008 2:26 pm | All times are GMT
navigation Forum index » Databases » Oracle » Server
Jump to:  

Similar Topics
Topic Author Forum Replies Last Post
No new posts Login problem Y.BulentAVCI Debian 1 Fri Jul 21, 2006 9:20 am
No new posts Capturing user login Information of windows sachin PHP 3 Fri Jul 21, 2006 5:44 am
No new posts Problem with Date::Manip Ted Byers Perl 1 Fri Jul 21, 2006 4:23 am
No new posts How to query on part of a date column? Barry Newton MySQL 4 Thu Jul 20, 2006 5:02 pm
No new posts gdm login screensaver Ron Croonenberg Setup 1 Wed Jul 19, 2006 8:33 pm

Mortgage Calculator | Western Union Money Transfer | Property in Spain | Web Advertising | Internet Advertising
Copyright © 2004-2005 DeniX Solutions SRL
 
Other DeniX Solutions sites: Unix/Linux blog |  electronics forum |  medicine forum |  science forum | 
Privacy Policy


Powered by phpBB © 2001, 2005 phpBB Group

[ Time: 0.1026s ][ Queries: 16 (0.0313s) ][ GZIP on - Debug on ]