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 <[EMAIL PROTECTED]> 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, > > [EMAIL PROTECTED] 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: [EMAIL PROTECTED] > > 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
