Hi Deepender,
I know of know builtin oracle view that will tell you this infomation.
At a former
job we were required to disable accounts that had not been used in the
last 60
days.
It has been a little while since I worked there (7 years to be exact) but
basically this is what we did
- created a tablecalled dbs_user_info with the fields (username,
create_date, last_login_date)
- copied the username and create field from dba_users into the fields,
initially we set last_login_date to be = create;
- Turned on auditing in the init.ora and audited successful logins
- at night we went through the sys.aud$ table and for each user that
existed updated the last_login_date truncating sys.aud$ when done
- weekly ran a batch job that found all users that last_login_date was
> 30 days
Beginning in 8i it might be easier to do this with an after login
trigger rather than auditing
Hope this helps,
John
that contained the username,
Deepender.Gupta_at_newpower.com wrote:
>Hi All,
>
>I want to have report of all the users who has not used their Oracle
>username for the last 30 and 60 days.
>Any views how can I get the report.
>
>Thanks,
>Deepender
>
