Home » RDBMS Server » Security » Solaris 9 10g - how to enfoce password complexity  () 1 Vote
icon6.gif  Solaris 9 10g - how to enfoce password complexity [message #138804] Fri, 23 September 2005 17:20 Go to next message
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!
Re: Solaris 9 10g - how to enfoce password complexity [message #138954 is a reply to message #138804] Sun, 25 September 2005 23:59 Go to previous messageGo to next message
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
Re: Solaris 9 10g - how to enfoce password complexity [message #139731 is a reply to message #138954] Thu, 29 September 2005 06:37 Go to previous message
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;

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


Current Time: Fri Mar 29 09:28:56 CDT 2024