溫馨提示×

溫馨提示×

您好，登錄后才能下訂單哦！

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務(wù)條款》

權(quán)限不足When Creating a Materialized View Log

發(fā)布時間：2020-06-28 08:50:41 來源：網(wǎng)絡(luò) 閱讀：865 作者：lych528 欄目：關(guān)系型數(shù)據(jù)庫

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 刪除

向AI問一下細(xì)節(jié)

免責(zé)聲明：本站發(fā)布的內(nèi)容（圖片、視頻和文字）以原創(chuàng)、轉(zhuǎn)載和分享為主，文章觀點不代表本網(wǎng)站立場，如果涉及侵權(quán)請聯(lián)系站長郵箱：is@yisu.com進(jìn)行舉報，并提供相關(guān)證據(jù)，一經(jīng)查實，將立刻刪除涉嫌侵權(quán)內(nèi)容。

AI
助
手