| From: | Peter Eisentraut <peter_e(at)gmx(dot)net> |
|---|---|
| To: | Elmar(dot)Haneke(at)gmx(dot)de |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: [GENERAL] Access rescrictions |
| Date: | 1999-12-14 23:02:06 |
| Message-ID: | Pine.LNX.4.20.9912142358520.5253-100000@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On 1999-12-14, Elmar(dot)Haneke(at)gmx(dot)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(at)gmx(dot)net 75262 Uppsala
http://yi.org/peter-e/ Sweden
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ed Loehr | 1999-12-15 00:57:32 | Re: [GENERAL] Mailing Lists |
| Previous Message | David Shenk | 1999-12-14 22:53:49 | Re: pgsql-general-digest V1 #564 |