Re: GRANT ON ALL IN schema

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: GRANT ON ALL IN schema
Дата
Msg-id 343.1255372939@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: GRANT ON ALL IN schema  (Petr Jelinek <pjmodos@pjmodos.net>)
Ответы Re: GRANT ON ALL IN schema  (Jaime Casanova <jcasanov@systemguards.com.ec>)
Re: GRANT ON ALL IN schema  (Brendan Jurd <direvus@gmail.com>)
Список pgsql-hackers
Petr Jelinek <pjmodos@pjmodos.net> writes:
> [ latest GRANT ALL patch ]

I started looking at this, and the first thing I noticed was that it
adds TABLES, FUNCTIONS, and SEQUENCES as unreserved keywords.  Now
I'm not a fan of bloating the parser that way, but I have to admit
that "GRANT ON ALL TABLE IN SCHEMA" wouldn't read well.  What I am
wondering is whether we should not go back and adjust the syntax
for the default-ACLs patch to use the same keywords, ie not

ALTER DEFAULT PRIVILEGES ... GRANT ... ON TABLE TO ...

but

ALTER DEFAULT PRIVILEGES ... GRANT ... ON TABLES TO ...

Comments?
        regards, tom lane


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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Is FOR UPDATE an optimization fence?
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: EvalPlanQual seems a tad broken