missing GRANTED BY explanations

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.

On Saturday, September 30, 2023, PG Doc comments form <
noreply@postgresql.org> wrote:

In the documentation for revoke command, there is no description for
GRANTED
BY clause.

As the doc says read the grant page for more detailed information.
Repeating everything here was deemed redundant.

David J.