should we allow users with a predefined role to access pg_backend_memory_contexts view and pg_log_backend_memory_contexts function?
Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
From: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
To: PostgreSQL Hackers <pgsql-hackers@lists.postgresql.org>
Date: 2021-10-07T17:41:35Z
Lists: pgsql-hackers
Hi, In a typical production environment, the user (not necessarily a superuser) sometimes wants to analyze the memory usage via pg_backend_memory_contexts view or pg_log_backend_memory_contexts function which are accessible to only superusers. Isn't it better to allow non-superusers with an appropriate predefined role (I'm thinking of pg_monitor) to access them? Thoughts? Regards, Bharath Rupireddy.
Commits
-
Grant memory views to pg_read_all_stats.
- 77ea4f94393e 15.0 landed