Read only access, via functions only

From: "Webb Sprague" <webb(dot)sprague(at)gmail(dot)com>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Read only access, via functions only
Date: 2008-11-05 23:46:16
Message-ID: b11ea23c0811051546p718ae7cci26d7708343bd67eb@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Items 1 and 2 are so that the end user doesn't stomp on the data.

I want item 3 in order to force the application programmers (PHP) not
to craft their own select statements but to go through the API

Thoughts? I have about given up, but maybe somebody can make it easy for me.

Running version 8.2.something (stupid Linux Distros)

(I can post code if necessary, I am just feeling a little lazy...)

Thanks
W

Responses

Browse pgsql-general by date

  From Date Subject
Next Message ries van Twisk 2008-11-05 23:49:08 Re: Read only access, via functions only
Previous Message Joshua D. Drake 2008-11-05 23:34:21 Re: Are there plans to add data compression feature to postgresql?