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" |
|
来自: 桃花源士 > 《Oracle数据库》