Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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-04094: table string.string is constraining, trigger may not modify it

1 Answers  


PROC-00006: User does not have permission to perform a cluster registry operation on this key.

1 Answers  


PCC-02209: Macro invocation has incorrect number of arguments

1 Answers  


LPX-00319: The node specified is not valid

1 Answers  


ORA-36178: (XSAGGR01) To be used with AGGREGATE, AGGMAP workspace object must be declared with the AGGMAP command.

1 Answers  


RMAN-00577: PIPE requires that TARGET be specified on the command line

1 Answers  


ORA-32591: connect string too long

1 Answers  


O2I-00127: Illegal INITFUNC name

1 Answers  


NZE-28759: failure to open file

1 Answers  


DRG-10853: Catsearch does not support this operator

1 Answers  


ORA-09240: smpalo: error allocating PGA memory

1 Answers  


ORA-30625: method dispatch on NULL SELF argument is disallowed

1 Answers  


Categories