Thread: missing GRANTED BY explanations
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. Best regards.
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.