Hi Surya, On Thursday, September 17th, 2026 at 1:14 PM, surya poondla <[email protected]> wrote:
> Bharath pointed out one asymmetry already i.e pg_stat_activity shows > pid, datid, xid and xmin to unprivileged non-owners while > pg_xmin_horizon shows nothing, and this would be one in the other > direction if the ACL were ever loosened or EXECUTE granted directly. > Would it be worth applying HAS_PGSTAT_PERMISSIONS per row in the SRF? No view in PG mixes revoke from PUBLIC with permissions checks per row. pg_shmem_allocations, pg_backend_memory_contexts, pg_dsm_registry_allocations, and pg_aios all use the former only. This patch follows that convention, sets a conservative default, and trusts DBAs to configure access. -- Scott Ray
signature.asc
Description: OpenPGP digital signature
