doc sql-grant.html Synopsis error?

From: jian he <jian(dot)universality(at)gmail(dot)com>
To: pgsql-general list <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: doc sql-grant.html Synopsis error?
Date: 2023-04-08 12:58:40
Message-ID: CACJufxFjD1=HzPUYC=03G-iUPtj+_NYHD+qpSfPrjmPz3hyLPQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi.
--work as intended.
grant ALL PRIVILEGES on FUNCTION pg_catalog.pg_reload_conf() to test;
grant ALL PRIVILEGES on FUNCTION pg_reload_conf() to test;

-------------errors. it should be work, or I interpret the doc the wrong
way?
GRANT ALL PRIVILEGES ON FUNCTION pg_reload_conf() IN SCHEMA pg_catalog TO
test;
GRANT ALL PRIVILEGES ON FUNCTION pg_catalog.pg_reload_conf() IN SCHEMA
pg_catalog TO test;

doc: https://www.postgresql.org/docs/current/sql-grant.html

GRANT { EXECUTE | ALL [ PRIVILEGES ] }
ON { { FUNCTION | PROCEDURE | ROUTINE } *routine_name* [ ( [ [
*argmode* ] [ *arg_name* ] *arg_type* [, ...] ] ) ] [, ...]
| ALL { FUNCTIONS | PROCEDURES | ROUTINES } IN SCHEMA
*schema_name* [, ...] }
TO *role_specification* [, ...] [ WITH GRANT OPTION ]
[ GRANTED BY *role_specification* ]

I am using postgres 16, but the grant function part does not change.
What did I miss?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Achilleas Mantzios 2023-04-08 13:07:36 Re: doc sql-grant.html Synopsis error?
Previous Message Jerry Sievers 2023-04-08 04:27:55 Re: pg_ctlcluster is not stopping cluster