创建新用户分配表空间

conn / as sysdba //创建临时表空间  create temporary tablespace jbpm_temptempfile 'd:\oracle\product\10.1.0\oradata\orcl\jbpm\jpbm_temp.dbf'size 50 mautoextend on next 50m maxsize 20480mextent 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;