Re: Revoking usage of pg_catalog

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Revoking usage of pg_catalog
Дата
Msg-id 1178733179.7497.54.camel@state.g2switchworks.com
обсуждение исходный текст
Ответ на Revoking usage of pg_catalog  ("Daniel Cristian Cruz" <danielcristian@gmail.com>)
Ответы Re: Revoking usage of pg_catalog
Список pgsql-admin
On Wed, 2007-05-09 at 08:05, Daniel Cristian Cruz wrote:
> Hi there!
>
> Is it possible to revoke usage of pg_catalog for a specific user?
>
> The reason is to secure PostgreSQL. If a user can connect to a
> database, it could query pg_class, pg_attribute, pg_proc search for
> specific tables and if using dblink, even database passwords...

That's not security, it's obscurity.

You can grant / revoke access to anything a user should or should not be
able to access anyway.



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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Revoking usage of pg_catalog
Следующее
От: "Daniel Cristian Cruz"
Дата:
Сообщение: Re: Revoking usage of pg_catalog