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

NNL-00933: Requests refused, OTHER-DATA violation: number

1 Answers  


ORA-17510: Attempt to do i/o beyond file size

1 Answers  


ORA-36394: (XSMXCLEA04) When using CLEAR on the AGGMAP workspace object, CACHE is the only valid directive.

1 Answers  


NNL-00813: Average query processing time: string

1 Answers  


TNS-00289: Navigator: Disabled Interchange

1 Answers  


ORA-32334: cannot create prebuilt materialized view on a table already referenced by a MV

1 Answers  


ORA-02035: illegal bundled operation combination

1 Answers  


ORA-32141: get method does not match the type of the parameter

1 Answers  


DRG-12605: datatype of column number in COLUMNS list is not supported

1 Answers  


ORA-29387: no top-plans found in the pending area

1 Answers  


PLS-00624: USING clause must be used with either aggregate or pipelined functions

1 Answers  


ORA-03125: client-server protocol violation

1 Answers  


Categories