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

--最大2g
create tablespace DEMO datafile 'D:\MyProject\Tablespace\DEMO.dbf' size 50m autoextend on next 50m maxsize 2048m extent management local;
--无限扩展
create tablespace DEMO datafile 'D:\MyProject\Tablespace\DEMO .dbf' size 50m autoextend on next 50m maxsize unlimited extent management local;
//创建用户名密码，默认表空间为DEMO 
create user  <font size="5" color="red">test</font > identified by <font size="5" color="red">123456</font > default tablespace DEMO ;
//为用户赋予连接，修改，最高的权限
grant connect,resource,dba to affairs;