Обсуждение: BUG #9364: why pg_user_mappings can query by nonsuperuser?

Поиск
Список
Период
Сортировка

BUG #9364: why pg_user_mappings can query by nonsuperuser?

От
digoal@126.com
Дата:
The following bug has been logged on the website:

Bug reference:      9364
Logged by:          digoal.zhou
Email address:      digoal@126.com
PostgreSQL version: 9.3.3
Operating system:   CentOS 6.x
Description:

pg_user_mappings view has user and passowrd infomation , I think it is not
security that can query by the mapped user which is not superuser. why ?
I revoke the query privilege from PUBLIC, and the foreign table used normal,
so why not revoke default?