Only owners can ANALYZE tables...seems overly restrictive

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Only owners can ANALYZE tables...seems overly restrictive
Дата
Msg-id CAKFQuwZ6dhjTFV7Bwmehe1N3=k484y4mM22zuYjVEU2dq9V1aQ@mail.gmail.com
обсуждение исходный текст
Ответы Re: Only owners can ANALYZE tables...seems overly restrictive  (Tom Lane <tgl@sss.pgh.pa.us>)
Re: Only owners can ANALYZE tables...seems overly restrictive  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-general
Given the amount of damage a person with write access to a table can get into it seems pointless to not allow them to analyze the table after their updates - since best practices would say that normal work with a table should not be performed by an owner.

I should the check for whether a given user can or cannot analyze a table should be whether the user has INSERT, UPDATE, or DELETE privileges.

I suppose row-level-security might come into play here...

David J.

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

Предыдущее
От: Adrian Klaver
Дата:
Сообщение: Re: Designing tables based on user input and defined values
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Only owners can ANALYZE tables...seems overly restrictive