| From: | tony <tony(at)animaproductions(dot)com> |
|---|---|
| To: | "Lars Preben S(dot) Arnesen" <l(dot)p(dot)arnesen(at)usit(dot)uio(dot)no> |
| Cc: | postgres list <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: User permissions |
| Date: | 2002-03-12 14:06:59 |
| Message-ID: | 1015942019.5496.3.camel@vaio |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, 2002-03-12 at 14:49, Lars Preben S. Arnesen wrote:
> I'm writing a web application to access a Postgres database. I want
> the application to use a user with limited permissions - it should
> only be able to execute predefined functions in the database.
>
> I have been searching for the Postgres-way of doing this, but I din't
> find any solution.
>
> I have designed functions with pl/pgsql which do alter, insert, select
> and delete in the database, but I don't want the database user to be
> able to perform these actions without using the predefined functions.
>
> How can I do this?
What middleware are you using? If you are using Java/JSP then you fix
the permissions at the web page level.
Cheers
Tony Grant
--
RedHat Linux on Sony Vaio C1XD/S
http://www.animaproductions.com/linux2.html
Macromedia UltraDev with PostgreSQL
http://www.animaproductions.com/ultra.html
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Lars Preben S. Arnesen | 2002-03-12 14:15:01 | Re: User permissions |
| Previous Message | Lars Preben S. Arnesen | 2002-03-12 13:49:51 | User permissions |