看下面的脚本
create user uname
identified by ""
default tablespace TS_TAB_001
temporary tablespace TEMP
profile DEFAULT
quota unlimited on ts_tab_001
quota unlimited on ts_tab_002;
grant connect to uname;
grant resource to uname;
下面一句是指定了默认表空间:
default tablespace TS_TAB_001
这两句是赋予用户可以管理这两个表空间:
quota unlimited on ts_tab_001
quota unlimited on ts_tab_002