Re: USAGE on schema allowed by default?

Поиск
Список
Период
Сортировка
От Jochem van Dieten
Тема Re: USAGE on schema allowed by default?
Дата
Msg-id 3DE93319.2040506@oli.tudelft.nl
обсуждение исходный текст
Ответ на Re: USAGE on schema allowed by default?  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: USAGE on schema allowed by default?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Tom Lane wrote:
> Jochem van Dieten <jochemd@oli.tudelft.nl> writes:
>
>>I am having a problem with USAGE. If I create a schema, users other than
>>the owner can enumerate tables in that schema.
>
> This has nothing to do with USAGE on the schema; it is just a matter of
> being able to read the system catalogs.

<quote>
2.8.4. Schemas and Privileges

By default, users cannot see the objects in schemas they do not own.
</quote>

I seem to have misunderstood the meaning of object (the current wording
suggests to me that tables, views, sequences etc. are not just
unreadable, but also invisible). Is there an explanation of "objects"
somewhere?

Jochem


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: USAGE on schema allowed by default?
Следующее
От: "Greg Sabino Mullane"
Дата:
Сообщение: Problems with FTP mirror sites