Re: Read only access, via functions only - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Read only access, via functions only
Date
Msg-id 1225929198.22001.144.camel@jd-laptop.pragmaticzealot.org
Whole thread Raw
In response to Read only access, via functions only  ("Webb Sprague" <webb.sprague@gmail.com>)
Responses Re: Read only access, via functions only
List pgsql-general
On Wed, 2008-11-05 at 15:46 -0800, Webb Sprague wrote:
> Hi all
>
> Is there a away to set up a schema such that a certain role has (1)
> read only access to (2) all the tables, but (3) must use predefined
> functions to use that access?

you can set transactions read only but the user can turn them off. Use
views, functions and GRANT.

Joshua D. Drake

--


pgsql-general by date:

Previous
From: ries van Twisk
Date:
Subject: Re: Read only access, via functions only
Next
From: Tom Lane
Date:
Subject: Re: How to use index in WHERE int = float