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?
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 |