--创建表空间
create tablespace tableName datafile 'e:\oracle\dbName.dbf' size 1024M autoextend on next 100M maxsize unlimited;
CREATE SMALLFILE TEMPORARY TABLESPACE TEMPTEST TEMPFILE 'e:\oracle\dbName2.dbf' SIZE 100M EXTENT MANAGEMENT LOCAL UNIFORM SIZE 1M;

--创建用户
create user userName  identified by "password"   default tablespace tableName TEMPORARY TABLESPACE tableName2 account unlock;

 --授权：连接权限
grant connect to userName;

--授权：其它所有权限
grant resource to userName;
revoke connect from userName