Re: How to track user logon in Oracle 7.3.4

Hi Tom,

you can achieve this via modifying their profile. I assume they have the "DEFAULT" profile assigned. In sqlplus you do "alter profile DEFAULT limit password_life_time 60 idle_time 86400;". This makes sure that (a) they have to change their password after 60 days (they can change it to the same they already have but they have to do something) and (b) their session will be kicked out after 86400 minutes (= 60 days * 1440 minutes/day) of idling. If there is anybody connected to your database disconnect and reconnect them. The easiest way to enforce this is to bounce the instance.

Martin

Tom Chow wrote:
>
> Hi,
>
> I need to track which user is inactive last 60 days and disable the account
> if user is inactive. What is the best way to do this and which table/view
> needed to get this information. I know Oracle 8i has the feature but we are
> stuck with 7.3.4
>
> Thanks
> Tom
Received on Thu Jul 04 2002 - 07:20:01 CDT