ITPub博客

首页 > Linux操作系统 > Linux操作系统 > ORA-01931: cannot grant UNLIMITED TABLESPACE to a role on 10g

ORA-01931: cannot grant UNLIMITED TABLESPACE to a role on 10g

原创 Linux操作系统 作者:ad007520 时间:2012-05-09 23:03:16 0 删除 编辑
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/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论

注册时间:2009-06-28

  • 博文量
    137
  • 访问量
    248008