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-00325: archived log for thread string, wrong thread # string in header

1 Answers  


ORA-00204: error in reading (block string, # blocks string) of controlfile

1 Answers  


PCC-00133: Command line option MODE=ANSI required with option NLS_LOCAL=YES

1 Answers  


QSM-02072: requirements not satisfied for fast refresh of nested mv

1 Answers  


ORA-28104: input value for string is not valid

1 Answers  


ORA-09217: sfsfs: failed to resize file

1 Answers  


PCC-02337: cannot declare multi-dimensioned array for this type

1 Answers  


PROT-00301: Dump is not feasible when clusterware is running

1 Answers  


ORA-03288: both FREELIST GROUP and INSTANCE parameters may not be specified

1 Answers  


PCC-01001: Your Pro*COBOL authorization is about to expire

1 Answers  


ORA-13780: SQL statement does not exist.

1 Answers  


ORA-19719: length for operation name longer than string

1 Answers  


Categories