请注意,本文编写于 781 天前,最后修改于 781 天前,其中某些信息可能已经过时。
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.
SQL> conn ju/123aaa
Connected.