They need the query rewrite privilege
As you query the mastertable CBO will calculate and rewrite the query to
use the MV.
Hench grants on the tables making up the MV are all that is needed.

Tonny de Groot
DienstenCentrum van:
College voor zorgverzekeringen / College Toezicht Zorgverzekeringen



-----Oorspronkelijk bericht-----
Van: genegurevich
[mailto:oracledba-ezmlmshield-x3000598.[Email address protected]
Verzonden: woensdag 29 juni 2005 18:49
Aan: LazyDBA Discussion
Onderwerp: MV access





All:

If I have a MV on an existing table and the access on the underlying
table
is granted to my users; do I need to grant access on the MVs
separattely or is it taken care of via grants to the table?

thank you

Gene Gurevich



--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com
To unsubscribe: see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com
By using this list you agree to these
terms:http://www.lazydba.com/legal.html



Oracle LazyDBA home page