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



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

Answer / guest

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.

Please add more information about this Error

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

CLSR-01004: Failed to mount database

1 Answers  


ORA-13188: cell decode failed

1 Answers  


ORA-09889: osnTXtt: access error on oracle executable

1 Answers  


QSM-01106: MV, string, is stale with respect to some partition(s) in the base table(s)

1 Answers  


ORA-22311: type for attribute "string" does not exist

1 Answers  






ORA-04079: invalid trigger specification

1 Answers   TCS,


ORA-13503: Creating SYSAUX tablespace with invalid attributes

1 Answers  


QSM-01007: query has NOREWRITE hint

1 Answers  


ORA-16184: DB_UNIQUE_NAME string hashes to the same value as DB_UNIQUE_NAME string

1 Answers  


ORA-30084: invalid data type for datetime primary with time zone modifier

1 Answers  


SQL*Loader-00429: insufficient number of elements found for varray

1 Answers  


QSM-02134: agg(expr) requires correspondng MAX(expr) function

1 Answers  


Categories