SQL> alter system set _CHECK_PASSWORD_COMPLEXITY=true;
Succeed.
SQL> create user user1 identified by simple1;
YAS-02317 failed to check password complexity for password must contain at least 8 characters
SQL> create user user1 identified by Short1_;
YAS-02317 failed to check password complexity for password must contain at least 8 characters
SQL> create user user1 identified by Complex1;
YAS-02317 failed to check password complexity for password must contain at least 1 special character
SQL> create user user1 identified by Complex1_;
Succeed.
SQL> drop user user1;
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/70028812/viewspace-3070510/ ,如需转载,请注明出处,否则将追究法律责任。