Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id EF632633D86 for ; Mon, 1 Mar 2010 08:16:44 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 20250-01 for ; Mon, 1 Mar 2010 12:16:34 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from kuber.nabble.com (kuber.nabble.com [216.139.236.158]) by mail.postgresql.org (Postfix) with ESMTP id 8BC66632955 for ; Mon, 1 Mar 2010 08:16:34 -0400 (AST) Received: from isper.nabble.com ([192.168.236.156]) by kuber.nabble.com with esmtp (Exim 4.63) (envelope-from ) id 1Nm4Y4-0003lR-3n for pgsql-sql@postgresql.org; Mon, 01 Mar 2010 04:16:32 -0800 Message-ID: <27742718.post@talk.nabble.com> Date: Mon, 1 Mar 2010 04:16:32 -0800 (PST) From: rawi To: pgsql-sql@postgresql.org Subject: Re: kind of RULE on SELECT depending on existence of a WHERE condition In-Reply-To: <4B8B983B.4080205@archonet.com> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Nabble-From: only4com@web.de References: <27741669.post@talk.nabble.com> <4B8B983B.4080205@archonet.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.11 tagged_above=-10 required=5 tests=BAYES_05=-1.11 X-Spam-Level: X-Archive-Number: 201003/3 X-Sequence-Number: 33710 > Not quite the way you suggest. You could build a series of views with > the WHERE conditions built in to them, and grant permissions on those > though. Thank you very much for your help. Unfortunately is this not what I hoped... The permissions will be granted dynamic by the application out of the user-records and expressed in the WHERE flags. I'll need another approach... Cheers, Rawi -- View this message in context: http://old.nabble.com/kind-of-RULE-on-SELECT-depending-on-existence-of-a-WHERE-condition-tp27741669p27742718.html Sent from the PostgreSQL - sql mailing list archive at Nabble.com.