| From: | Craig Ringer <ringerc(at)ringerc(dot)id(dot)au> |
|---|---|
| To: | John R Pierce <pierce(at)hogranch(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Using Postgresql as application server |
| Date: | 2011-08-18 00:02:11 |
| Message-ID: | 4E4C5683.1090003@ringerc.id.au |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin pgsql-general |
On 18/08/2011 12:35 AM, John R Pierce wrote:
> 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).
Column level, actually :-) and they can control read access as well as
write access.
Further control for writes can be applied using triggers that RAISE
EXCEPTION when they don't like something.
--
Craig Ringer
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Craig Ringer | 2011-08-18 00:14:10 | Re: Unable to login with phppgadmin on a remote host |
| Previous Message | Tom Browder | 2011-08-17 23:20:00 | Unable to login with phppgadmin on a remote host |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Fujii Masao | 2011-08-18 01:26:19 | Re: streaming replication: one problem & several questions |
| Previous Message | Tatsuo Ishii | 2011-08-17 23:22:27 | Re: Failover architecture |