wouldn't it be easier to create a new profile or change the default
profile so that there was a password_life_time of 30 or 60 and then set
the grace period to a day or so and then check for users whose accounts
are locked?
- Ora NT DBA <orantdba_at_netscape.net> wrote:
> 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
>
> 1. created a tablecalled dbs_user_info with the fields (username,
> create_date, last_login_date)
>
> 2. copied the username and create field from dba_users into the
> fields,
> initially we set last_login_date to be = create;
>
> 3. Turned on auditing in the init.ora and audited successful logins
>
> 4. 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
>
> 5. 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
> >
> >
> >
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ora NT DBA
> INET: orantdba_at_netscape.net
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing
> Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Do You Yahoo!?
Yahoo! Greetings - Send FREE e-cards for every occasion!
http://greetings.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Rachel Carmichael
INET: wisernet100_at_yahoo.com
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Thu Feb 28 2002 - 14:41:47 CST
