User permissions

From: "Lars Preben S(dot) Arnesen" <l(dot)p(dot)arnesen(at)usit(dot)uio(dot)no>
To: pgsql-general(at)postgresql(dot)org
Subject: User permissions
Date: 2002-03-12 13:49:51
Message-ID: yfrg0357v5s.fsf@lpsa.uio.no
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

--
Lars Preben

Responses

Browse pgsql-general by date

  From Date Subject
Next Message tony 2002-03-12 14:06:59 Re: User permissions
Previous Message Frank_Lupo Frank_Lupo 2002-03-12 13:32:07 create link table other db