Re: BUG #1145: silent REVOKE failures

Поиск
Список
Период
Сортировка
От Fabien COELHO
Тема Re: BUG #1145: silent REVOKE failures
Дата
Msg-id Pine.LNX.4.58.0406091733460.23525@sablons.cri.ensmp.fr
обсуждение исходный текст
Ответ на Re: BUG #1145: silent REVOKE failures  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: BUG #1145: silent REVOKE failures
Список pgsql-bugs
> >> For the TODO, I would suggest something general:
> >> - fix grant/revoke wrt SQL standard, validate errors, warnings and successes.
>
> > Tom, is this done?
>
> I think so.  At least, we're a lot closer to spec than we were.

Indeed.

Maybe the validation part could be improved somehow, with test cases
build from the sql specification and the expected behavior checked
against the actual behavior.

What I derived from the many discussion and time I spent on the standard
is that there is a lot of subtlety involved.

So maybe the following TODO could be kept:

 - validate grant/revoke (error, warning, success0 wrt sql standard

I may be interested in implementing ROLEs someday, and such tests would be
welcome just to check that nothing is broken.

--
Fabien Coelho - coelho@cri.ensmp.fr

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: BUG #1145: silent REVOKE failures
Следующее
От: "Jie Liang"
Дата:
Сообщение: Re: [ADMIN] out of memory error