MVR配置过程中的授权问题

11 |

1 | 2014-9-10 21:37:07 | 显示全部楼层 |阅读模式

我对用户授予了GRANT create ANY MATERIALIZED VIEW TO mvadmin;
为什么执行CREATE MATERIALIZED VIEW suk.testmv AS SELECT * FROM [email protected]
还是提示
ORA-01031: insufficient privileges
之后我把dba权限也给了mvadmin，问题依旧
但是我要是执行CREATE MATERIALIZED VIEW testmv AS SELECT * FROM [email protected]
是可以的

使用道具举报