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

Поиск
Список
Период
Сортировка
От Josh Kupershmidt
Тема Re: [GENERAL] column-level update privs + lock table
Дата
Msg-id AANLkTim-ay7r4u4R4+Mie6oUpVk89GO06pua3q0h+28H@mail.gmail.com
обсуждение исходный текст
Ответы Re: [GENERAL] column-level update privs + lock table  (Robert Haas <robertmhaas@gmail.com>)
Re: [GENERAL] column-level update privs + lock table  (KaiGai Kohei <kaigai@ak.jp.nec.com>)
Список pgsql-hackers
[Moving to -hackers]

On Fri, Oct 15, 2010 at 3:43 AM, Simon Riggs <simon@2ndquadrant.com> wrote:
> On Mon, 2010-10-11 at 09:41 -0400, Josh Kupershmidt wrote:
>> On Thu, Oct 7, 2010 at 7:43 PM, Josh Kupershmidt <schmiddy@gmail.com> 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?
>
> Seems so to me, but you raise on Hackers.

Thanks, Simon. Attached is a simple patch to let column-level UPDATE
privileges allow a user to LOCK TABLE in a mode higher than Access
Share. Small doc. update and regression test update are included as
well. Feedback is welcome.

Thanks
Josh

Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Jaime Casanova
Дата:
Сообщение: Re: How to reliably detect if it's a promoting standby
Следующее
От: Tom Lane
Дата:
Сообщение: Re: UNION DISTINCT in doc