--创建表空间
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
