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
oracle
ororacle
with 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