Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Oracle password dictionary

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US