Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: determine Oracle account last access time
Audit create session... would be one way.
HTH.
Paul
"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
Received on Sun Oct 07 2001 - 08:52:53 CDT