Re: [GENERAL] column-level update privs + lock table

2010-10-15 Thread Simon Riggs
On Mon, 2010-10-11 at 09:41 -0400, Josh Kupershmidt wrote: > On Thu, Oct 7, 2010 at 7:43 PM, Josh Kupershmidt wrote: > > > I noticed that granting a user column-level update privileges doesn't > > allow that user to issue LOCK TABLE with any mode other than Access > > Share. > > Anyone think thi

Re: [GENERAL] column-level update privs + lock table

2010-10-11 Thread Josh Kupershmidt
On Thu, Oct 7, 2010 at 7:43 PM, Josh Kupershmidt wrote: > I noticed that granting a user column-level update privileges doesn't > allow that user to issue LOCK TABLE with any mode other than Access > Share. Anyone think this could be added as a TODO? Josh -- Sent via pgsql-general mailing lis

[GENERAL] column-level update privs + lock table

2010-10-07 Thread Josh Kupershmidt
Hi all, I noticed that granting a user column-level update privileges doesn't allow that user to issue LOCK TABLE with any mode other than Access Share. The documentation page for LOCK TABLE claims: "All other forms of LOCK require at least one of UPDATE, DELETE, or TRUNCATE privileges.", and I d