topic Oracle Password Complexity Configuration in Application Development and Automation Discussions

Oracle Password Complexity Configuration

Former Member — Mon, 14 May 2007 09:43:35 GMT

Hi All,

I want to configured password complexity on oracle database level like,

• The password has a minimum length.

• The password is not the same as the username.

• The password has at least one alpha, one numeric, and one punctuation mark character.

• The password is not a simple or obvious word, such as welcome, account, database, or user.

• The password differs from the previous password by at least 3 characters.

Could you please someone let me know that where should I configured these setting means which configuration file.

I also found on the internet that the Oracle's password complexity verification routine can be specified using a PL/SQL script (UTLPWDMG.SQL). Is this file where I set the parameters as per the requirement or should I use init_<sid>.ora file.

Thanks in advance.

Regards,

Harish

Re: Oracle Password Complexity Configuration

Former Member — Wed, 16 May 2007 09:10:00 GMT

Hi Experts,

Is someone can help me?

Regards,

Harish

Re: Oracle Password Complexity Configuration

Former Member — Thu, 17 May 2007 07:12:25 GMT

Dear Harish,

Im not too good with it myself, however i can provide you with some help as ur in need of it.

Kindly view the following links, they might be useful for you:

1). http://orafaq.com/faqdbase.htm

2). PDF Document:

http://www.oracle.com/technology/deploy/security/database-security/pdf/oow2006_secureconfig.pdf

3). http://www.rocket99.com/techref/oracle8305.html

4). http://www.rocket99.com/techref/oracle_dba.html

Hope it helps!!

ps:

Please reward points if useful