oracle用户管理

更改用户表空间限额

01 全局

grant unlimited tablespace to pub01;

02 针对某个表空间

alter user pub01 quota umlimited on users;
alter user pub01 quota 10m on users;  //限制多少，user用户只能在users表空间中用10m

03 回收

revoke unlimited tablespace from pub01;
alter user pub01 quota 0 on users;