能授权成功其实是一个bug。在11.2版本里,授权不会报错,但是会有问题,用户实际上并不会从角色中得到这个权限:Until 11.1.0.7, granting UNLIMITED TABLESPACE privilege to a role raised ORA-1931 error. On 11.2, granting UNLIMITED TABLESPACE privilege to a role succeeds, but CREATE TABLE statement still raises ORA-1950.
raised ORA-1931 error. On 11.2, granting UNLIMITED TABLESPACE privilege
to a role succeeds, but CREATE TABLE statement still raises ORA-1950.