Deny access materialzsed view

Hi

I created a materialized view to manage editings via a real postgres
view. The view has some rules to deliver all inserts, updates and
deletes to the underlaying table with the appropriate privileges,
insert, update and delete, for members of an editing role. To avoid
editings on the underlaying table I want to deny any access except
select access to the table for all users. Does anyone outside has an
idea how to manage the described situation?

I'll appreciate any hint.

Regards
Horst

------------------------------------------------

Dr. Horst Düster
Stv. Amtschef / kantonaler GIS-Koordinator

Kanton Solothurn
Bau- und Justizdepartement
Amt für Geoinformation
SO!GIS Koordination
Rötistrasse 4
CH-4501 Solothurn

Telefon ++41(0)32 627 25 32
Mobil ++41(0)79 511 54 12
Telefax ++41(0)32 627 22 14

mailto:horst(dot)duester(at)bd(dot)so(dot)ch
http://www.agi.so.ch