创建和删除Oracle数据库用户、表空间

1. 创建普通用户
  >create user username identified by username;
  >grant create tablespace, resource ,connect to username;
2. 创建表空间和用户
    2.1 创建临时表空间
  >create temporary tablespace DB_TEMP
   tempfile '/opt/oracle/oradata/mydb/ts_db_temp01.dbf'
   size 200M
   autoextend on
   next 50M maxsize unlimited
   extent management local;
    2.2 创建数据表空间
  >create tablespace DB_TABLESPACE
   logging
   datafile '/opt/oracle/oradata/mydb/ts_db_data01.dbf'
   size 500M 
   autoextend on 
   next 50M  maxsize unlimited
   extent management local;
    2.3 创建用户并指定表空间
  >create user username identified by password
   default tablespace DB_TABLESPACE
   temporary tablespace DB_TEMP;
    2.4 给用户授予权限
  >grant connect,resource to username;
3. 删除Oracle数据库用户和表空间
    3.1 删除Oracle数据库用户
  >drop user user cascade;
    3.2 删除Oracle数据库空间
  >drop tablespace tsname including contents and datafiles;