Re: Using Postgresql as application server

From: John R Pierce <pierce(at)hogranch(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Using Postgresql as application server
Date: 2011-08-17 16:35:10
Message-ID: 4E4BEDBE.7050700@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On 08/17/11 7:40 AM, Merlin Moncure wrote:
> GRANT/REVOKE only constrain read/write privileges to a database.

at a table level, and even distinguishing between INSERT (writing new
data) and UPDATING (updating existing data). you can get even finer
granularity, using functions with SECURITY_DEFINER based permissions.

--
john r pierce N 37, W 122
santa cruz ca mid-left coast

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Tom Browder 2011-08-17 23:20:00 Unable to login with phppgadmin on a remote host
Previous Message Chris Travers 2011-08-17 16:28:33 Re: Using Postgresql as application server

Browse pgsql-general by date

  From Date Subject
Next Message Rich Shepard 2011-08-17 16:42:15 Re: Not Seeing Syntax Error
Previous Message David Johnston 2011-08-17 16:31:50 Re: Not Seeing Syntax Error