Oracle数据库创建用户名实例过程

1.SQL> conn sys/tiger as sysdba;

已连接。

2.SQL> show user;

USER 为 "SYS"

3.SQL> create user stu user identified by orcl account unlock;

create user stu user identified by orcl account unlock

*

第 1 行出现错误:

ORA-00922: 选项缺失或无效

4.SQL> create user stu user identified by orcl account unlock;

create user stu user identified by orcl account unlock

*

第 1 行出现错误:

ORA-00922: 选项缺失或无效

5.SQL> create user stu user identified by orcl;

create user stu user identified by orcl

*

第 1 行出现错误:

ORA-00922: 选项缺失或无效

6.SQL> create user stu_user identified by orcl account unlock;

用户已创建。

7.SQL> grant connect,resource to stu_user;

授权成功。

8.SQL> conn stu_user/orcl;

已连接。

9.SQL> show user;

USER 为 "STU_USER"