Re: - Mailing list pgsql-general

From Chris Bitmead
Subject Re:
Date
Msg-id 392A8DD2.2FCA05CB@bitmead.com
Whole thread Raw
In response to ...  (Emmanuel Motchane <Emmanuel.Motchane@cmla.ens-cachan.fr>)
List pgsql-general
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.

If this is some kind of security measure, it won't work because in the
extreme case anybody can just open a socket and send the appropriate
protocol down it (like you can with any client server database).

Otherwise I suggest you ask your user's politely or see if the postgres
grant permissions can do what you want.

pgsql-general by date:

Previous
From: Alex Pilosov
Date:
Subject: Re: plperl extensions
Next
From: Ron Peterson
Date:
Subject: Re: loading data from flat text file