Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Oracle Password Complexity Configuration

Former Member

‎05-14-2007 10:43 AM

0 Kudos

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

2 REPLIES 2

Former Member

‎05-16-2007 10:10 AM

0 Kudos

Hi Experts,

Is someone can help me?

Regards,

Harish

Former Member

‎05-17-2007 8:12 AM

0 Kudos

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