1 密码只由字母组成,创建成功
SQL> create user ju identified by aa;
User created.
2 密码只由数字组成,创建成功
SQL> create user ju identified by 123;
User created.
3 密码由字母+数字组成,创建成功
SQL> create user ju identified by chen123;
User created.
4 密码由数字+字母组成,创建失败
SQL> create user ju identified by 123aaa;
create user ju identified by 123aaa
*
ERROR at line 1:
ORA-00922: missing or invalid option
5 密码由数字+密码组成时,必须加双引号才能成功
SQL> create user ju identified by "123aaa";
User created.
Connected.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/29785807/viewspace-1273786/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/29785807/viewspace-1273786/