Re: Disable databse listing for non-superuser (\l) ?

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: Disable databse listing for non-superuser (\l) ?
Дата
Msg-id dcc563d10907241915w8376cb9i4cbb6ca15048e5a9@mail.gmail.com
обсуждение исходный текст
Ответ на Disable databse listing for non-superuser (\l) ?  ("Brian A. Seklecki" <lavalamp@spiritual-machines.org>)
Ответы Re: Disable databse listing for non-superuser (\l) ?
Re: Disable databse listing for non-superuser (\l) ?
Список pgsql-general
On Fri, Jul 24, 2009 at 5:02 PM, Brian A.
Seklecki<lavalamp@spiritual-machines.org> wrote:
> All:
>
> Any suggestions on how-to, or comments on a potential NFR, to disable
> non-superuser's from viewing the database list via \l?

So, is this a misguided attempt at security through obscurity, or are
you looking at limiting the noise that users see when they look at
databases?  If it's for security through obscurity, I don't have any
real advice, as any changes to do that in a manner that really limits
the ability of the user to look up that data are likely to have
unintended negative consequences.

OTOH, if you just want to limit what folks see to make their life
easier, then I'd suggest making the changes in psql and change the
queries it uses to look up the databases the user has access to.

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

Предыдущее
От: Andrew Radamis
Дата:
Сообщение: Re: FATAL: root page 3 of "pg_class_oid_index" has level 0, expected 1
Следующее
От: "Brian A. Seklecki"
Дата:
Сообщение: Re: Disable databse listing for non-superuser (\l) ?