创建表空间

CREATE TABLESPACE CSM_STAND
LOGGING
DATAFILE 'D:\oracle\product\10.2.0\oradata\orcl\CSM_STAND.DBF' 
SIZE 32M 
AUTOEXTEND ON 
NEXT 32M MAXSIZE 2048M
EXTENT MANAGEMENT LOCAL;

创建用户并设置表空间

create user csm_stand identified by csm default tablespace csm_stand;

给用户赋权限

grant connect,resource to csm_stand;
grant create any sequence to csm_stand;
grant create any table to csm_stand;
grant delete any table to csm_stand;
grant insert any table to csm_stand;
grant select any table to csm_stand;
grant unlimited tablespace to csm_stand;
grant execute any procedure to csm_stand;
grant update any table to csm_stand;
grant create any view to csm_stand;

给用户赋予DBA权限

grant dba to csm_stand;

取消用户的所有权限

revoke dba from <username>

删除表空间

alter tablespace CSM_TEST offline;
DROP TABLESPACE CSM_TEST INCLUDING CONTENTS AND DATAFILES;