oracle 创建用户

C:\Users\Administrator>sqlplus

SQL*Plus: Release 11.1.0.6.0 - Production on 星期一 3月 15 08:57:28 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

请输入用户名:  sys@orcl as sysdba
输入口令:

连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> create user funny identified by niit default tablespace users temporary tab
lespace temp quota 100 m on users account unlock;

用户已创建。

SQL> commit;

提交完成。

SQL> conn  wangjun/wangjun @orcl
ERROR:
ORA-01045: user WANGJUNlacks CREATE SESSION privilege; logon denied

警告: 您不再连接到 ORACLE。
SQL> exit

C:\Users\Administrator>sqlplus

SQL*Plus: Release 11.1.0.6.0 - Production on 星期一 3月 15 09:00:21 2010

Copyright (c) 1982, 2007, Oracle.  All rights reserved.

请输入用户名:  sys/sys@orcl as sysdba

连接到:
Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> grant create session to wangjun;

授权成功。

SQL> commit;

提交完成。

SQL> conn wangjun/wangjun@orcl
已连接。
SQL> conn sys/sys@orcl as sysdba
已连接。
SQL> grant create any table to wangjun;

授权成功。

SQL> commit;

提交完成。