Horton

Grant memory views to pg_read_all_stats.

Jeff Davis <jdavis@postgresql.org>

View on postgr.es
Commit: 77ea4f94393eb4a16df32b573bf053bedaef2e09
Author: Jeff Davis <jdavis@postgresql.org>
Date: 2021-10-27T21:06:30Z
Releases: 15.0 
Grant memory views to pg_read_all_stats.

Grant privileges on views pg_backend_memory_contexts and
pg_shmem_allocations to the role pg_read_all_stats. Also grant on the
underlying functions that those views depend on.

Author: Bharath Rupireddy <bharath.rupireddyforpostgres@gmail.com>
Reviewed-by: Nathan Bossart <bossartn@amazon.com>
Discussion: https://postgr.es/m/CALj2ACWAZo3Ar_EVsn2Zf9irG+hYK3cmh1KWhZS_Od45nd01RA@mail.gmail.com

Files

PathChange+/−
doc/src/sgml/catalogs.sgml modified +4 −2
src/backend/catalog/system_views.sql modified +4 −0
src/include/catalog/catversion.h modified +1 −1
src/test/regress/expected/privileges.out modified +47 −0
src/test/regress/sql/privileges.sql modified +25 −0

Documentation touched

Discussion