Re: Read only access, via functions only

From: "Joshua D(dot) Drake" <jd(at)commandprompt(dot)com>
To: Webb Sprague <webb(dot)sprague(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Read only access, via functions only
Date: 2008-11-05 23:53:18
Message-ID: 1225929198.22001.144.camel@jd-laptop.pragmaticzealot.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

--

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2008-11-06 00:13:37 Re: How to use index in WHERE int = float
Previous Message ries van Twisk 2008-11-05 23:49:08 Re: Read only access, via functions only