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-14255: table is not partitioned by Range, Composite Range or List method

1 Answers  


ORA-12319: database (link name string) is already open

1 Answers  


ORA-19695: fixed table x$krbmsft has not been populated

1 Answers  


ORA-29306: datafile string is not online

1 Answers  


TNS-00504: Operation not supported

1 Answers  






NNO-00710: server's cache will be dumped to the trace file in number seconds

1 Answers  


PLS-00213: package STANDARD not accessible

1 Answers  


ORA-16058: standby database instance is not mounted

1 Answers  


TNS-00135: Missing TNS error message file

1 Answers  


ORA-29265: HTTP header not found

1 Answers  


TNS-00516: Permission denied

1 Answers  


ORA-27192: skgfcls: sbtclose2 returned error - failed to close file

1 Answers  


Categories