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

ORA-16620: one or more databases could not be contacted for a delete operation

1 Answers  


SQL*Loader-00480: EXPRESSION may not be used with elements of a collection.

1 Answers  


ORA-15117: command only operates on one diskgroup

1 Answers  


ORA-02495: cannot resize file string, tablespace string is read only

1 Answers  


ORA-14150: missing SUBPARTITION keyword

1 Answers  






DRG-50863: string assignment failed

1 Answers  


ORA-12822: duplicate option in PARALLEL clause

1 Answers  


ORA-06979: X.25 Driver: server cannot start oracle

1 Answers  


NNL-00507: Shows, sets, or cancels the time when an auto-refresh query is next issued

1 Answers  


PLS-00428: an INTO clause is expected in this SELECT statement

1 Answers  


ORA-23403: refresh group "string"."string" already exists

1 Answers  


ORA-31617: unable to open dump file "string" for write

1 Answers  


Categories