restrict column-level GRANTs to a single relation?

Поиск
Список
Период
Сортировка
От kevin brintnall
Тема restrict column-level GRANTs to a single relation?
Дата
Msg-id 20060119085013.GA43061@rufus.net
обсуждение исходный текст
Ответы Re: restrict column-level GRANTs to a single relation?  (Peter Eisentraut <peter_e@gmx.net>)
Re: restrict column-level GRANTs to a single relation?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Fellow hackers,

I'm curious about the best way to handle something like this:
   GRANT SELECT (col1, col2, col3) ON table1, table2 TO grantee;

Is it reasonable to restrict this to a single relation, and throw an error
if multiple relations are specified?  That would require the preceding
grant to be specified as:
   GRANT SELECT (col1, col2, col3) ON table1 TO grantee;   GRANT SELECT (col1, col2, col3) ON table2 TO grantee;

The SQL standards don't seem to mandate the first form (unless I
misread?)..  Do y'all think this is a reasonable compromise?

-- kevin brintnall =~ <kbrint@rufus.net>


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

Предыдущее
От: Leandro Guimarães Faria Corcete Dutra
Дата:
Сообщение: Re: Surrogate keys (Was: enums)
Следующее
От: David Fetter
Дата:
Сообщение: Re: Surrogate keys (Was: enums)