Re: Documentation clarification re: ANALYZE

David G. Johnston <david.g.johnston@gmail.com>

From: "David G. Johnston" <david.g.johnston@gmail.com>
To: Isaac Morland <isaac.morland@gmail.com>
Cc: PostgreSQL Hackers <pgsql-hackers@postgresql.org>
Date: 2019-08-07T22:01:31Z
Lists: pgsql-hackers
On Wed, Aug 7, 2019 at 2:42 PM Isaac Morland <isaac.morland@gmail.com>
wrote:

> Thanks. So presumably I would also have permission if I have SET ROLEd to
> the owner, or to a role which is an INHERIT member of the owner.
>

Yes, the table ownership role check walks up the role membership hierarchy
if "inherit" is on for the current role.

David J.

Commits

  1. Doc: document permissions required for ANALYZE.