From: | Travis Bauer <trbauer(at)indiana(dot)edu> |
---|---|
To: | Emmanuel Motchane <Emmanuel(dot)Motchane(at)cmla(dot)ens-cachan(dot)fr> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: |
Date: | 2000-05-24 17:45:59 |
Message-ID: | Pine.GSO.4.21.0005241243580.3991-100000@school.cs.indiana.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
One problem you may have with this is that if a function accesses some
table, the user who uses that function must also have permissions on the
table. I have a similar problem. I'd like to give permissions on a view,
but not on the table underlying the view (the view serves to filter out
some records the user shouldn't see). I can't give permission to use view
without giving permission to use the table.
----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------
On Tue, 23 May 2000, Emmanuel Motchane wrote:
> Hi,
>
> I am trying to figure out how to restrict user access to a database to
> a few defined functions, so that users could use the database (and update
> it) but only through a set of procedures, written for exemple in C and
> using the Server Programming
> interface.
>
> I am new to PostgreSQL so sorry if this question is irrelevant to this
> list.
>
> Thanks in advance,
>
> Emmanuel Motchane
>
>
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Holmgren | 2000-05-24 17:59:15 | Why is PostgreSQL 7.0 SQL semantics different from Oracle's? |
Previous Message | Travis Bauer | 2000-05-24 17:41:53 | Re: 7.0 installation problem, help please :-( |