首页 > 其他 > 详细

权限不足When Creating a Materialized View Log

时间:2018-04-25 15:19:35      阅读:246      评论:0      收藏:0      [点我收藏+]
The privileges required to create a materialized view log are directly related
to the privileges necessary to create the underlying objects associated with
a materialized view log.

  • If you own the master table, you can create an associated materialized view log
    if you have the CREATE TABLE privilege (included in the RESOURCE role)

  • If you are creating a materialized view log for a table in another user‘s schema,
    you must have the CREATE ANY TABLE and COMMENT ANY TABLE privileges (not included
    in the RESOURCE role), as well as either the SELECT privilege for the master
    table or SELECT ANY TABLE.

In either case, the owner of the materialized view log must have sufficient quota
in the tablespace intended to hold the materialized view log or must have the
UNLIMITED TABLESPACE system privilege.

物化视图日志一般情况以MLOG$_开头,在dba_objects里查询,可以用
drop materialized view log 删除

权限不足When Creating a Materialized View Log

原文:http://blog.51cto.com/2012ivan/2107697

(0)
(0)
   
举报
评论 一句话评论(0
关于我们 - 联系我们 - 留言反馈 - 联系我们:wmxa8@hotmail.com
© 2014 bubuko.com 版权所有
打开技术之扣,分享程序人生!