Can I enforce a minimum number of chars in a pwd
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Can I enforce a minimum number of chars in a pwd

  1. #1
    Join Date
    Jan 2000
    Location
    Chester, England.
    Posts
    818
    Is there a way at the DB level (an init param maybe or utility) that will configure my database to not accept passwords below a minimum length? (I'm running 8.1.5 by the way)

  2. #2
    Join Date
    Nov 2000
    Location
    Birmingham, UK
    Posts
    360
    There is an Oracle supplied function that does the following:

    Oracle's password complexity verification routine can be specified using a PL/SQL script (UTLPWDMG.SQL), which sets the default profile parameters.

    The password complexity verification routine performs the following checks:

    The password has a minimum length of 4.

    The password is not the same as the userid.

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

    The password does not match simple words like welcome, account, database, or user.

    The password differs from the previous password by at least 3 letters.

    Otherwise you can write your own. a full explanation with examples are in the Oracle 8i Admin Guide documentation

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width