From: Düster Horst <Horst.Duester@bd.so.ch>
To: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Deny access materialzsed view
Date: Wed, 24 Nov 2010 08:57:59 +0100
Message-ID: <H00002eb08436aca.1290585478.srsofaioi6145.ktso.ch@MHS> (raw)
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.duester@bd.so.ch
http://www.agi.so.ch
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: Horst.Duester@bd.so.ch
Subject: Re: Deny access materialzsed view
In-Reply-To: <H00002eb08436aca.1290585478.srsofaioi6145.ktso.ch@MHS>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox