Last logon of a user

[meeradevi]

Is it possible to determine the last login date and time by a user into an oracle instance.

I do not need any suggestion for future use but want to determine when a list of my existing users had last logged on into my oracle instance.

Urgent !

 

[DBAwhosaysNIE]

if you don't have auditing turned on your options are pretty limited. if you have an old fashioned client/server type architecture the listener log will tell you what host connected when to what instance but not what Oracle user they connected as. that may allow you to trace access to someone's workstation. if they modified data you could use log miner to extract DML/DDL (as well as timestamps) executed by an Oracle user but not selects.

 

[Beilstwh]

There is nothing that stores the last logon time for a user, however you could easly setup a database logon trigger that would record the user name and date when they logged in (and also logout time if your wanted it).

Bill
Oracle DBA/Developer
New York State, USA

 

[SantaMufasa]

But wait, Meeradevi, aren't you running an Oracle 8.0.6 instance? If so, I believe that you cannot do a logon trigger unless you are running at least 8.1.x. (That's why I didn't post earlier .)

Mufasa
(aka Dave of Sandy, Utah, USA)
[

http://www.dasages.com:

Providing low-cost remote Database Admin services]
Click here to join Utah Oracle Users Group on Tek-Tips if you use Oracle in Utah USA.