菜鸟学习oracle常见错误

create user sc identified by songchi;

 User created.

SQL> conn sc/songchi
ERROR:
ORA-01045: user SC lacks CREATE SESSION privilege; logon denied

//需要把用户解锁。
Warning: You are no longer connected to ORACLE.

现在在重新试一次呢。估计这次能成。

SQL> conn sc/songchi
ERROR:

ORA-01045: user SC lacks CREATE SESSION privilege; logon denied

//原来是还要create session的权限。

SQL> grant create session to sc;

Grant succeeded.

SQL> conn sc/songchi;
Connected.//嘿嘿，终于处理好了。哎，经验不够啊。