oracle 新建用户

--临时表空间

create temporary tablespace TS_TEMP_BIDM

tempfile 'D:\app\oracle\oradata\dwdb\TS_TEMP_BIDM.dbf' 
size 100m 
autoextend on 
next 250m maxsize unlimited 
extent management local; 

--默认表空间
create tablespace TS_BIDM
logging 
DATAFILE 'D:\app\oracle\oradata\dwdb\TS_BIDM1.dbf' 
size 100m 
autoextend on 
next 10m 
maxsize unlimited 
extent management local; 

--创建用户并制定表空间，赋权限
create user username identified by password
default tablespace TS_BIDM 
temporary tablespace TS_TEMP_BIDM; 
grant CREATE SESSION , CREATE VIEW , RESOURCE to  username ;
grant unlimited tablespace to username ;