SQL> grant unlimited tablespace to dba_role;
grant unlimited tablespace to dba_role
*
ERROR at line 1:
ORA-01931: cannot grant UNLIMITED TABLESPACE to a role
The Error ORA-01931: cannot grant UNLIMITED TABLESPACE to a role is an Expected
behaviour.
This has been identified as BUG 12873187 . 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. It will be fixed in 11.2.0.4 vesion. If
you need patch for 11.2.0.2 version , we need to raise a backport request.
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/21993926/viewspace-723195/,如需转载,请注明出处,否则将追究法律责任。