diff options
| author | Nathan Bossart <nathan@postgresql.org> | 2024-02-14 11:48:29 -0600 |
|---|---|---|
| committer | Nathan Bossart <nathan@postgresql.org> | 2024-02-14 11:48:29 -0600 |
| commit | 8d8afd48d3f298bc4d8ab2b115cc39550132bde7 (patch) | |
| tree | 3f414a22a0719e4257f08cff45b8b25274c40c3a /src/backend | |
| parent | 3e8235ba4f9cc3375b061fb5d3f3575434539b5f (diff) | |
| download | postgresql-8d8afd48d3f298bc4d8ab2b115cc39550132bde7.tar.gz postgresql-8d8afd48d3f298bc4d8ab2b115cc39550132bde7.zip | |
Allow pg_monitor to execute pg_current_logfile().
We allow roles with privileges of pg_monitor to execute functions
like pg_ls_logdir(), so it seems natural that such roles would also
be able to execute this function.
Bumps catversion.
Co-authored-by: Pavlo Golub
Reviewed-by: Daniel Gustafsson
Discussion: https://postgr.es/m/CAK7ymcLmEYWyQkiCZ64WC-HCzXAB0omM%3DYpj9B3rXe8vUAFMqw%40mail.gmail.com
Diffstat (limited to 'src/backend')
| -rw-r--r-- | src/backend/catalog/system_functions.sql | 4 |
1 files changed, 4 insertions, 0 deletions
diff --git a/src/backend/catalog/system_functions.sql b/src/backend/catalog/system_functions.sql index 346cfb98a04..fe2bb50f46d 100644 --- a/src/backend/catalog/system_functions.sql +++ b/src/backend/catalog/system_functions.sql @@ -777,6 +777,10 @@ GRANT EXECUTE ON FUNCTION pg_ls_logicalmapdir() TO pg_monitor; GRANT EXECUTE ON FUNCTION pg_ls_replslotdir(text) TO pg_monitor; +GRANT EXECUTE ON FUNCTION pg_current_logfile() TO pg_monitor; + +GRANT EXECUTE ON FUNCTION pg_current_logfile(text) TO pg_monitor; + GRANT pg_read_all_settings TO pg_monitor; GRANT pg_read_all_stats TO pg_monitor; |