Re: How to track user logon in Oracle 7.3.4

I forgot to mention you must ensure that resource_limit = true for the idling timeout to work.

To make sure that the first password aging is hitting as well, you must issue an "alter user ... identified by values '...'" where you get the passwords from dba_users.

Martin

Martin Haltmayer wrote:
>
> 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:44:13 CDT