Обсуждение: missing GRANTED BY explanations

Поиск
Список
Период
Сортировка

missing GRANTED BY explanations

От
PG Doc comments form
Дата:
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.

Re: missing GRANTED BY explanations

От
"David G. Johnston"
Дата:
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.

Re: missing GRANTED BY explanations

От
"David G. Johnston"
Дата:
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.