Postgres Pro
Downloads
Home   >   mailing lists

Re: kind of RULE on SELECT depending on existence of a WHERE condition - Mailing list pgsql-sql

From rawi
Subject Re: kind of RULE on SELECT depending on existence of a WHERE condition
Date
Msg-id 27742718.post@talk.nabble.com
Whole thread Raw
In response to Re: kind of RULE on SELECT depending on existence of a WHERE condition  (Richard Huxton <dev@archonet.com>)
Responses Re: kind of RULE on SELECT depending on existence of a WHERE condition
List pgsql-sql
Tree view 
> 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.

pgsql-sql by date:

Previous
From: Richard Huxton
Date:
Subject: Re: kind of RULE on SELECT depending on existence of a WHERE condition
Next
From: Michael Gould
Date:
Subject: placement of stored procedures and contrib modules