oracle创建用户sql

CREATE TABLESPACE   xj_xmcg
   DATAFILE 'D:\oracle\oradata\fush\xj_xmcg0.DBF'

   SIZE 50M

   AUTOEXTEND ON NEXT 10M

   PERMANENT ONLINE;


DROP TABLESPACE  xj_xmcg INCLUDING CONTENTS;

drop user xj_xmcg cascade ;

create user xj_xmcg 
   identified by xj_xmcg
   default tablespace xj_xmcg  
   temporary tablespace temp  
   profile default  
   account unlock;  

grant connect,resource,dba to xj_xmcg;