无法从非postgres用户获取pg_settings

Question

我有以下查询来获取max_running_jobs的设置。

select *    
from pg_settings 
where name = 'cron.max_running_jobs';

我能够从postgres用户获得记录，但不能与non-postgres用户。

有我错过的授权/许可吗?

Answer 1

by this REF: https://pgpedia.info/p/pg_settings.html

权限应该是:

GRANT SELECT, UPDATE ON pg_settings TO PUBLIC;

你可以确认它运行:

SELECT grantee, string_agg(privilege_type, ', ') AS privileges
FROM information_schema.role_table_grants 
WHERE table_name='pg_settings'   
GROUP BY grantee;