These are the rules for Oracle Passwords:
- The password contains no fewer than 8 characters and does not exceed 30 characters.
- The password is not the same as the user name, nor is it the user name spelled backward or with the numbers 1–100 appended.
- The password is not the same as the server name or the server name with the numbers 1–100 appended.
- The password is not too simple, for example,
welcome1,database1,account1,user1234,password1,oracle,oracle123,computer1,abcdefg1, orchange_on_install. - The password is not
oracleororaclewith the numbers 1–100 appended. - The password includes at least 1 numeric and 1 alphabetic character.
- The password differs from the previous password by at least 3 letters.You can make changes to this default behavior by editing the UTLPWDMG.SQL scriptCheck my prior blogs on how to disable this feature altogether. I do this for my training environments. I wish to use the same password as the user ID and also turn off case-sensitivity...
No comments:
Post a Comment