Re: Set password criteria in Oracle 9i R2

Hi

or look at $ORACLE_HOME/rdbms/admin/utlpwdmg.sql which includes a sample password verification function and some alter profile commands that you can modify the function and alter profile statement to suit your needs. The sample does a length check, a check for one digit, one char and one punctuation, the other two can be done with the profile.

hth

kind regards

Pete

-- 
Pete Finnigan
email:pete_at_petefinnigan.com
Web site: http://www.petefinnigan.com - Oracle security audit specialists
Book:Oracle security step-by-step Guide - see http://store.sans.org for details.