Re: How to control pg_catalog results for each users?

Поиск
Список
Период
Сортировка
От Ron
Тема Re: How to control pg_catalog results for each users?
Дата
Msg-id d7305b7d-9ea4-8c96-45ee-300bd7e6d344@gmail.com
обсуждение исходный текст
Ответ на Re: How to control pg_catalog results for each users?  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-general
On 1/30/23 02:41, Laurenz Albe wrote:
> On Mon, 2023-01-30 at 14:00 +0900, hirose shigeo(廣瀬 繁雄 □SWC○ACT) wrote:
>> all users can get the all of table name , table structure and other
>> information from pg_catalog, which is considered a security problem.
> The belief that restricting that will improve security goes by the name
> of "security by obscurity", which is usually not considered robust.

Your description sounds a whole lot like PostgreSQL's row level security.

-- 
Born in Arizona, moved to Babylonia.



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

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: alter table impact on view
Следующее
От: Laurenz Albe
Дата:
Сообщение: Re: Does statement_timeout apply to commit?