Re: determine Oracle account last access time

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Sun, 7 Oct 2001 15:44:10 +0200
Message-ID: <ts0rvmr63i7331@news.demon.nl>

"Orna Berlinsky" <ornab_at_amdocs.com> wrote in message news:4e2fb3ee.0110070540.41e3d635_at_posting.google.com...
> Hi,
>
> My development database is very active and contains many users.
>
> I would like a way to help me identify inactive accounts ,(e.g
> accounts that were not accessed for a month)
>
> Any suggestions ? ( trigger , procedure ? )
>
> Thanks
> Orna

audit session
You need to enable auditing though by changing the init.ora parameter audit_trail to db.
This has worked since 6.0, so I don't think a trigger or procedure is necessary.

Hth,

Sybrand Bakker, Senior Oracle DBA Received on Sun Oct 07 2001 - 08:44:10 CDT