oracle create tablespace、user and grant

--创建表空间

create tablespace tableName datafile 'e:oracle/dbName.dbf' 
size 1024M autoextend on next 100M maxsize unlimited;

 

--创建用户

create user userName
       identified by "password"
       default tablespace tableName;

 --授权：连接权限

grant connect to userName;

 

--授权：其它所有权限

grant resource to userName;