Oracle删除用户、创建表空间、创建临时表空间、创建用户、授权

删除用户

drop user wsjgxt cascade;
DROP TABLESPACE wsjgxt_data  INCLUDING CONTENTS AND DATAFILES;
DROP TABLESPACE wsjgxt_tmp  INCLUDING CONTENTS AND DATAFILES;

创建表空间

create tablespace hz7sp2_data    datafile  			'D:\app\Administrator\oradata\orcl\hz7sp2_data.dbf'   
	size 100m  	autoextend on  	next 32m maxsize 2048m;

创建临时表空间

create temporary tablespace hz7sp2_tmp tempfile  'D:\app\Administrator\oradata\orcl\hz7sp2_tmp.dbf' 
size 100m  	autoextend on  	next 32m maxsize 2048m;

创建用户

CREATE USER hz7sp2  IDENTIFIED BY hz7sp2  DEFAULT   TABLESPACE hz7sp2_data  TEMPORARY TABLESPACE hz7sp2_tmp ;

授权

grant DBA,CREATE SESSION ,UNLIMITED TABLESPACE,CREATE VIEW,SELECT ANY TABLE,SELECT ANY DICTIONARY to hz7sp2  ;
grant CREATE ANY PROCEDURE,CREATE ANY SEQUENCE,CREATE ANY TABLE to hz7sp2  with admin option;