Re: Oracle password dictionary

From: Sunil Bhola <oraclebhola_at_yahoo.com>
Date: Thu, 16 Jun 2005 06:34:25 -0700 (PDT)
Message-ID: <20050616133425.70761.qmail@web31614.mail.mud.yahoo.com>

Hi Thomas,  

I think the column PTIME of USER$ data dictionary will tell you when the password got changed.  

select name,to_char(ptime, 'dd-mon-yyyy') from sys.user$;  

Please let me know the result.  

Regards,
Sunil Bhola
thomas_arnezeder_at_non.agilent.com wrote:
Got a question about password strength. It's possible to enforce the complexity of a password in the password_verify_function. But is there a way to check an oracle pw against a dictionary at the time the pw gets changed (and perhaps reject the new pw)? On UX you have the ckpw tool where you can check against a pw dictionary.

Thanks,
Thomas
--

http://www.freelists.org/webpage/oracle-l

Regards,  

Sunil Bhola
Oracle_Expert, Moderator                     

---

Discover Yahoo!
 Have fun online with music videos, cool games, IM & more. Check it out!

--

http://www.freelists.org/webpage/oracle-l Received on Thu Jun 16 2005 - 09:39:34 CDT