Re: [GENERAL] Access rescrictions
От | Peter Eisentraut |
---|---|
Тема | Re: [GENERAL] Access rescrictions |
Дата | |
Msg-id | Pine.LNX.4.20.9912142358520.5253-100000@localhost.localdomain обсуждение исходный текст |
Ответ на | Access rescrictions (Elmar.Haneke@gmx.de) |
Ответы |
RE: [GENERAL] Access rescrictions
|
Список | pgsql-general |
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
В списке pgsql-general по дате отправления: