Re: GRANT/REVOKE: Allow column-level privileges

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: GRANT/REVOKE: Allow column-level privileges
Дата
Msg-id 24506.1138583800@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: GRANT/REVOKE: Allow column-level privileges  (Euler Taveira de Oliveira <eulerto@yahoo.com.br>)
Ответы Re: GRANT/REVOKE: Allow column-level privileges  (kevin brintnall <kbrint@rufus.net>)
Список pgsql-hackers
Euler Taveira de Oliveira <eulerto@yahoo.com.br> writes:
> --- kevin brintnall <kbrint@rufus.net> escreveu:
>> if user matches an acl for the column
>>    .. and priv is granted, then permit
>>    .. else priv is not granted, reject
>> else fall through to table privileges

> Wouldn't it be more cheap to test the most-common-case table privileges
> first?

Also, the "reject" bit is wrong: if you have table-level privileges
then that implies privileges on all columns.  So it should be just
an additional test made after failing to find the desired table-level
privilege, and before erroring out.
        regards, tom lane


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

Предыдущее
От: Euler Taveira de Oliveira
Дата:
Сообщение: Re: GRANT/REVOKE: Allow column-level privileges
Следующее
От: "Mark Woodward"
Дата:
Сообщение: Re: Want to add to contrib.... xmldbx