Received: from maia.hub.org (maia-2.hub.org [200.46.204.251]) by mail.postgresql.org (Postfix) with ESMTP id 3927B1336B42 for ; Wed, 24 Nov 2010 04:09:08 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia, port 10024) with ESMTP id 77978-06 for ; Wed, 24 Nov 2010 08:09:00 +0000 (UTC) X-Greylist: delayed 00:10:51.184878 by SQLgrey-1.7.6 Received: from in-mail1.so.ch (in-mail1.so.ch [193.135.75.102]) by mail.postgresql.org (Postfix) with ESMTP id 548A61337B4E for ; Wed, 24 Nov 2010 04:08:59 -0400 (AST) X-IronPort-AV: E=Sophos;i="4.59,247,1288566000"; d="scan'208,217";a="24721795" Received: from srsofaioi11504.ktso.ch (HELO so.ch) ([10.36.21.182]) by out-mail1.so.ch with ESMTP; 24 Nov 2010 08:57:59 +0100 Received: from srsofaioi6145.ktso.ch (localhost.localdomain [127.0.0.1]) by so.ch (8.13.8/8.13.8) with ESMTP id oAO7vxoB024608 for ; Wed, 24 Nov 2010 08:57:59 +0100 Date: Wed, 24 Nov 2010 08:57:59 +0100 From: =?UTF-8?Q?D=C3=BCster_Horst?= To: pgsql-admin Message-ID: Subject: Deny access materialzsed view x-scalix-Hops: 1 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="2_0_5f_24ee9172MHTML_=_01" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.31 tagged_above=-10 required=5 tests=BAYES_20=-0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_MED=-2.3, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201011/209 X-Sequence-Number: 36175 --2_0_5f_24ee9172MHTML_=_01 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Hi=20 =20 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? =20 I'll appreciate any hint. =20 Regards Horst =20 ------------------------------------------------=20 Dr. Horst D=FCster=20 Stv. Amtschef / kantonaler GIS-Koordinator=20 Kanton Solothurn=20 Bau- und Justizdepartement=20 Amt f=FCr Geoinformation=20 SO!GIS Koordination=20 R=F6tistrasse 4=20 CH-4501 Solothurn=20 Telefon ++41(0)32 627 25 32=20 Mobil ++41(0)79 511 54 12=20 Telefax ++41(0)32 627 22 14=20 mailto:horst.duester@bd.so.ch=20 http://www.agi.so.ch=20 =20 --2_0_5f_24ee9172MHTML_=_01 Content-Type: text/html Content-Transfer-Encoding: quoted-printable Content-Disposition: inline

Hi=20

I c= reated a=20 materialized view to manage editings via a real postgres view. The view h= as some=20 rules to deliver all inserts, updates and deletes to the underlaying tabl= e with=20 the appropriate privileges, insert, update and delete, for members o= f an=20 editing role. To avoid editings on the underlaying table I want to deny a= ny=20 access except select access to the table for all users. Does an= yone=20 outside has an idea how to manage the described situation?

I'll app= reciate any=20 hint.

Regards

Horst

------------------------------------------------=20

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

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

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

mailto:horst.duester@bd.so.ch<= /FONT>=20
http://www.agi.so.ch=20

--2_0_5f_24ee9172MHTML_=_01--