sequence privileges in information schema

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема sequence privileges in information schema
Дата
Msg-id 1303849452.12063.3.camel@vanquo.pezone.net
обсуждение исходный текст
Ответы Re: sequence privileges in information schema  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
We currently don't represent the sequence privileges in the information
schema.  We could perhaps do a subset of them.

In the SQL standard, there is only the USAGE privilege, and its only
purpose (AFAICT) is to allow the NEXT VALUE FOR expression.
PostgreSQL's nextval(), by contrast, requires both USAGE and UPDATE
privileges.

So with regard to the information schema, we could

a) show USAGE privileges as is (and perhaps SELECT and UPDATE as is, as
well)

b) show USAGE privileges only if UPDATE is also granted

c) show nothing, avoiding the whole issue.

Any ideas?




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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: Bad COMPACT_ALLOC_CHUNK size in tsearch/spell.c?
Следующее
От: Tom Lane
Дата:
Сообщение: Re: SR standby hangs