Only owners can ANALYZE tables...seems overly restrictive

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Only owners can ANALYZE tables...seems overly restrictive
Date: 2016-02-29 04:10:10
Message-ID: CAKFQuwZ6dhjTFV7Bwmehe1N3=k484y4mM22zuYjVEU2dq9V1aQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2016-02-29 04:58:24 Re: Only owners can ANALYZE tables...seems overly restrictive
Previous Message Adrian Klaver 2016-02-28 20:04:44 Re: Designing tables based on user input and defined values