conn / as sysdba 

//创建临时表空间  

create temporary tablespace jbpm_temp
tempfile 'd:\oracle\product\10.1.0\oradata\orcl\jbpm\jpbm_temp.dbf'
size 50 m
autoextend on next 50m maxsize 20480m
extent management local 



//创建数据表空间  

 create tablespace jbpm_data  
 logging
 datafile 'd:\oracle\product\10.1.0\oradata\orcl\jbpm\jbpm_data.dbf' 
 size 50m
 autoextend on 
 next 50m maxsize 20480m
 extent management local;
//========删除创建的表空间的方法==========
drop tablespace jpbm_temp
 including contents and datafiles cascade constraints;
//========删除创建的表空间的方法==========

//创建用户并指定表空间  

create user jbpm identified by jbpm  
default tablespace jbpm_data 
temporary tablespace jbpm_temp;  


//给用户授予权限  

grant connect,resource to jbpm;  

//撤权： revoke   权限...   from 用户名; 

//删除用户命令 
 
drop user user_name cascade;