Re: [BUGS] information_schema.columns.character_octet_length unavailable if no access to pg_database

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: [BUGS] information_schema.columns.character_octet_length unavailable if no access to pg_database
Дата
Msg-id 5705.1501768394@sss.pgh.pa.us
обсуждение исходный текст
Ответ на [BUGS] information_schema.columns.character_octet_length unavailable if noaccess to pg_database  (Fabien Meghazi <amigrave@gmail.com>)
Список pgsql-bugs
Fabien Meghazi <amigrave@gmail.com> writes:
> On any database, when the pg_database access is restraint for standard
> users:
>     psql> REVOKE ALL ON pg_database FROM public;
> it not possible anymore to query the field character_octet_length from the
> view information_schema.columns:

It's pretty hard to get excited about that --- it seems like it's going
to be about the least of your problems, if you start revoking public read
permissions on random system catalogs.  Postgres isn't really designed
with that sort of change in mind.
        regards, tom lane


-- 
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs

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

Предыдущее
От: Krystian Szladewski
Дата:
Сообщение: [BUGS] "could not open relation with OID XXX" when using recreated index insql function
Следующее
От: rbiro@interfacefinancial.com
Дата:
Сообщение: [BUGS] BUG #14770: postgres_fdw assumes foreign table is in postgres