- CREATE ANY MATERIALIZED VIEW
Create materialized views in any schema.
- ALTER ANY MATERIALIZED VIEW
Alter materialized views in any schema.
- DROP ANY MATERIALIZED VIEW
Drop materialized views in any schema.
- QUERY REWRITE
This privilege has been deprecated. No privileges are needed for a user to enable
rewrite for a materialized view that references tables or views in the user's own
schema.
- GLOBAL QUERY REWRITE
Enable rewrite using a materialized view when that materialized view references
tables or views in any schema.
- ON COMMIT REFRESH
. Create a refresh-on-commit materialized view on any table in the database.
. Alter a refresh-on-demand materialized view on any table in the database to
refresh-on-commit.
创建物化视图需要的权限
最新推荐文章于 2023-10-12 15:59:52 发布