OraFAQ Forum: Security » Solaris 9 10g - how to enfoce password complexity

Home » RDBMS Server » Security » Solaris 9 10g - how to enfoce password complexity (

) 1 Vote

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Solaris 9 10g - how to enfoce password complexity [message #138804]

Fri, 23 September 2005 17:20

nmacdannald
Messages: 460
Registered: July 2005
Location: Stockton, California - US...

Senior Member

How do most dba's enforce password complexity. Would the enforcement unvalidate someone's password or just enforce complexity on the new ones?

Thanks!

Report message to a moderator

Re: Solaris 9 10g - how to enfoce password complexity [message #138954 is a reply to message #138804]

Sun, 25 September 2005 23:59

tarundua
Messages: 1080
Registered: June 2005
Location: India

Senior Member

hi

A script named utlpwdmg.sql is already provided by Oracle to implement password complexity. You can find it at $ORACLE_HOME/rdbms/admin location.

Amend this script as per your requirement and run as sys.

do some documentation reading also, it would be better.

regards,
tarun

Report message to a moderator

Re: Solaris 9 10g - how to enfoce password complexity [message #139731 is a reply to message #138954]

Thu, 29 September 2005 06:37

girish.rohini
Messages: 744
Registered: April 2005
Location: Delhi (India)

Senior Member

Or else, you can create a function of your own & use that for password verification. You can include any complexity in this function, that you want to have for your database.

Syntax:
alter profile profile-name limit password_verify_function function-name;

eg:
ALTER PROFILE developer LIMIT
password_verify_function uw_pwd_verification;

Report message to a moderator

Previous Topic:	Security Oracle when use with internet
Next Topic:	EMC Control Center Oracle Database access

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu May 01 14:02:19 CDT 2025