Skip site navigation (1) Skip section navigation (2)

Re: Re[2]: postgres not use table access permissions ?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Partyka Robert <bobson(at)saturn(dot)alpha(dot)pl>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Re[2]: postgres not use table access permissions ?
Date: 2000-11-03 20:34:44
Message-ID: 8069.973283684@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackers
Partyka Robert <bobson(at)saturn(dot)alpha(dot)pl> writes:
> if I do 
> # grant UPDATE, INSERT, SELECT on a to user1;
> it was treat as:
> # grant UPDATE, INSERT, DELETE, SELECT on a to user1;

Yeah.  The underlying permission set is actually "read, write, append"
(where write access also allows append).  So UPDATE and DELETE are
treated the same, and allowing them also allows INSERT.  This is
something that probably oughta be changed some day.  That'll doubtless
break some user applications, though, since the true permission set is
user-visible (try psql's \z command for example).

			regards, tom lane

In response to

pgsql-hackers by date

Next:From: Larry RosenmanDate: 2000-11-03 20:45:11
Subject: Re: Summary: what to do about INET/CIDR
Previous:From: Ian Lance TaylorDate: 2000-11-03 20:29:32
Subject: Re: [HACKERS] 7.0.3 branded

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group