1. 创建一个表空间
create tablespace TEST
datafile 'G:/data/test.dbf'
seze 20M
2.创建一个用户,默然表空间是TEST
create user arowana identified by arowana
default tablespace TEST
3.赋予用户权限
grant create session,create table to macro
4.修改改用户对改表空间的权限,这样该用户就可以在TEST上建表了
alter user arowana quota unlimited on TEST
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
4.修改改用户对改表空间的权限,这样该用户就可以在TEST上建表了
![](/Images/OutliningIndicators/None.gif)