Re: Inactive users
- From: "Yechiel Adar" <adar76@xxxxxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 26 Dec 2004 20:15:10 +0200
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.
>
>
>
> --
> //www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
