oracle10g创建表空间用户授权

# su - oracle

$ sqlplus /nolog

SQL> conn / as sysdba

Connected.

SQL> create tablespace tbs_name datafile '/opt/oracle10/oradba/dbname.dbf' size 10m; //建表空间`

Tablespace created.

SQL> create user myname identified by mypass default tablespace tbs_name;　　　　　　//建用户

User created.

SQL> grant connect to myname;　　　　　　//连接权限

Grant succeeded.

SQL> grant resource to myname;　　　　　　//其他所有权限

Grant succeeded.

 

 

 

 

SQL> drop user myname cascade;//删除用户

User dropped.

SQL> DROP TABLESPACE tbs_name INCLUDING CONTENTS AND DATAFILES; 　　//删除表空间