oracle命令行建用户赋权限

localhost.localdomain@/home/oracle>>sqlplus /nolog

SQL*Plus: Release 11.2.0.1.0 Production on Mon May 21 09:58:44 2012

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

SQL> connect / as sysdba
Connected.
SQL> show user
USER is "SYS"
SQL> create user test identified by test;

User created.

SQL> grant connect,resource,dba to test;

Grant succeeded.

SQL> drop user test cascade;     //注：删除用户

User dropped.

SQL>

注：新添用户时的默认表空间设置为USERS
alter database default tablespace USERS;