Re: [GENERAL] Access rescrictions

On 1999-12-14, Elmar.Haneke@gmx.de mentioned:

> I'm looking for an solution to restrict the access to show an part of an Table only:
> In an customer-database it should be possible to list the bills of an certain customer,
> but it should be restricted to generate/summarize a list of all bills.
>
> "SELECT * FROM Bills"  should be restricted
> "SELECT * FROM Bills WHERE CustomerID=?" should be allowed for any CustomerID.
>
> Is there an solution to this problem in PostgreSQL?

No. I think hardly any database engine will be able to restrict access
according to query semantics. You will have to do this via your client
application.

--
Peter Eisentraut                  Sernanders väg 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden