Oracle创建表空间及用户并授权

--建立临时表空间
create temporary tablespace user_temp
tempfile 'D:\app\Administrator\oradata\orcl\user_temp.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;

--建立表空间
create tablespace user
logging
datafile 'D:\app\Administrator\oradata\orcl\user.dbf'
size 50m
autoextend on
next 50m maxsize 20480m
extent management local;

--创建用户并授权 
create user username identified by password
default tablespace user
temporary tablespace user_temp;
grant connect,resource,dba to username ;