-- 必须有密码,且密码不能为空串! scott@TBWORA> conn / as sysdba 已连接。 sys@TBWORA> create user identified by ""; create user identified by "" * 第 1 行出现错误: ORA-01935: 缺失用户或角色名 sys@TBWORA> create user lym2 identified by ""; create user lym2 identified by "" * 第 1 行出现错误: ORA-01741: 非法的零长度标识符 sys@TBWORA> create user lym2; create user lym2 * 第 1 行出现错误: ORA-01938: 必须为 CREATE USER 指定 IDENTIFIED BY
sys@TBWORA> create user lym2 identified by lym2;用户已创建。
----create user identified by ""这样创建的用户,密码是什么呢? 这样的语句怎能通过,修改后 create user 用户名 identified by 密码;
scott@TBWORA> conn / as sysdba
已连接。
sys@TBWORA> create user identified by "";
create user identified by ""
*
第 1 行出现错误:
ORA-01935: 缺失用户或角色名
sys@TBWORA> create user lym2 identified by "";
create user lym2 identified by ""
*
第 1 行出现错误:
ORA-01741: 非法的零长度标识符
sys@TBWORA> create user lym2;
create user lym2
*
第 1 行出现错误:
ORA-01938: 必须为 CREATE USER 指定 IDENTIFIED BY
这样的语句怎能通过,修改后
create user 用户名 identified by 密码;