Re: How to track user logon in Oracle 7.3.4

"Tom Chow" <cmc3232_at_yahoo.com> wrote in message news:aevvv0$jq8$1_at_bcarh8ab.ca.nortel.com...
> 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
>
>

I do think Oracle 6 already has the feature Just change/set audit_trail :
audit_trail = db
in init.ora and bounce the database.
Then
isssue
audit connect;
and look in dba_audit_session for results.

Disable the account would imply in Oracle 7.3.4 revoke create session privilege.

Hth

--
Sybrand Bakker
Senior Oracle DBA

to reply remove '-verwijderdit' from my e-mail address