oracle create tablespace、user and grant

--建立資料表空間
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