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