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@xxxxxxxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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

Other related posts: