Re: missing GRANTED BY explanations - Mailing list pgsql-docs

From David G. Johnston
Subject Re: missing GRANTED BY explanations
Date
Msg-id CAKFQuwbcyGXmow8zRgMZuCb-VjYzpoGnpnAn6c1LfCU=6MmZLQ@mail.gmail.com
Whole thread Raw
In response to missing GRANTED BY explanations  (PG Doc comments form <noreply@postgresql.org>)
List pgsql-docs
On Sat, Sep 30, 2023 at 1:56 PM PG Doc comments form <noreply@postgresql.org> wrote:
The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/16/sql-revoke.html
Description:

Hi,
In the documentation for revoke command, there is no description for GRANTED
BY clause.
please explain that what will happen when using this clause in revoke
command.


Grants specifications include the role doing the granting.  So when you remove a grant you have to also specify which role the grant came from.  That clause lets you specify said role explicitly.

David J.

pgsql-docs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: Not clear spelling about transaction
Next
From: "David G. Johnston"
Date:
Subject: Re: missing GRANTED BY explanations