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.
最后修改:2022 年 02 月 28 日
如果觉得我的文章对你有用,请随意赞赏