Re: Re: Privileges for INFORMATION_SCHEMA.SCHEMATA (was Re: [DOCS] Small clarification in "34.41. schemata")

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Re: Privileges for INFORMATION_SCHEMA.SCHEMATA (was Re: [DOCS] Small clarification in "34.41. schemata")
Дата
Msg-id 1378780046.14736.3.camel@vanquo.pezone.net
обсуждение исходный текст
Ответ на Re: Re: Privileges for INFORMATION_SCHEMA.SCHEMATA (was Re: [DOCS] Small clarification in "34.41. schemata")  (Bruce Momjian <bruce@momjian.us>)
Список pgsql-hackers
On Sat, 2013-09-07 at 14:01 -0400, Bruce Momjian wrote:
> > >     pg_has_role(n.nspowner, 'USAGE')
> > >     OR has_schema_privilege(n.oid, 'CREATE, USAGE')
> > > 
> > > As things stand, a non-superuser won't see "public", "pg_catalog",
> > > nor even "information_schema" itself in this view, which seems a
> > > tad silly.
> > 
> > I agree it would make sense to change this.
> 
> Is this the patch you want applied?  The docs are fine? 

I have committed it with a documentation update.




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

Предыдущее
От: Noah Misch
Дата:
Сообщение: Re: Re: [bug fix] strerror() returns ??? in a UTF-8/C database with LC_MESSAGES=non-ASCII
Следующее
От: Noah Misch
Дата:
Сообщение: Re: [bug fix] strerror() returns ??? in a UTF-8/C database with LC_MESSAGES=non-ASCII