Only owners can ANALYZE tables...seems overly restrictive - Mailing list pgsql-general

From David G. Johnston
Subject Only owners can ANALYZE tables...seems overly restrictive
Date
Msg-id CAKFQuwZ6dhjTFV7Bwmehe1N3=k484y4mM22zuYjVEU2dq9V1aQ@mail.gmail.com
Whole thread Raw
Responses 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>)
List 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 by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: Designing tables based on user input and defined values
Next
From: Tom Lane
Date:
Subject: Re: Only owners can ANALYZE tables...seems overly restrictive