Re: Inactive users

I wrote a trigger that insert the deatils of every login into my table. Once a week I run a job that deletes all the old logins of the user except the last one.

Having such a table lets you easily find the user that their last access was more then 90 day ago.

Yechiel Adar
Mehish Computer Services
----- Original Message -----
From: "J. Dex" <cemail4_at_adelphia.net>
To: <oracle-l_at_freelists.org>
Sent: Monday, December 20, 2004 7:55 AM
Subject: Inactive users

> I want to get a list of all the users in the database that have been
> inactive for more than 90 days. What is the best way to do that? What
> query/table should be used?
>
> Thanks.
>
>
>
> --
> http://www.freelists.org/webpage/oracle-l

--
http://www.freelists.org/webpage/oracle-l