创建新用户分配表空间
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;
