ORA-30372: fine grain access policy conflicts with materialized view

ORA-30372: fine grain access policy conflicts with materialized view
Cause: A fine grain access control procedure has applied a non-null policy to the query for the materialized view.
Action: In order for the materialized view to work correctly, any fine grain access control procedure in effect for the query must return a null policy when the materialized view is being created or refreshed. This may be done by ensuring that the usernames for the creator, owner, and invoker of refresh procedures for the materialized view all receive a null policy by the user-written fine grain access control procedures.

0 条评论
分类：大数据

默认排序时间排序

1 个回答

小智 2018-08-30 16:48

ORA-30372：细粒度访问策略与物化视图冲突,
.原因：细粒度访问控制过程已将非空策略应用于物化视图的查询。,
.操作：为了使物化视图正常工作，对于查询生效的任何细粒度访问控制过程都必须在创建或刷新物化视图时返回空策略。这可以通过确保用于物化视图的刷新过程的创建者，所有者和调用者的用户名都通过用户编写的精细访问控制过程接收空策略来完成。,
.

aiaiDBA

13718043309

010-86462881

ORA-30372: fine grain access policy conflicts with materialized view

1 个回答

相似问题