Re: Browse database , schema

Поиск
Список
Период
Сортировка
От Michael Fuhr
Тема Re: Browse database , schema
Дата
Msg-id 20060716122523.GA28622@winnie.fuhr.org
обсуждение исходный текст
Ответ на Browse database , schema  (qnick@spec.net.pl)
Список pgsql-general
On Sat, Jul 15, 2006 at 04:04:50AM -0700, qnick@spec.net.pl wrote:
> I have a question about rights to browse a database and a schema's
> structure. Is this normal that user who isn't have any permission as
> select to same db or scheme may explore it and see tables (table's fields
> etc.) ?

Users who can connect to a database can query that database's system
catalogs.

> How prohibit that ? Thanks

Don't allow users to connect to databases whose structures you don't
want the users to browse.

--
Michael Fuhr

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

Предыдущее
От: Christian Kratzer
Дата:
Сообщение: Re: Scaleable DB structure for counters...
Следующее
От: Adam Witney
Дата:
Сообщение: Re: I have a questions, can you help-me ?