pgsql: Hide other user's pg_stat_ssl rows

From: Peter Eisentraut <peter(at)eisentraut(dot)org>
To: pgsql-committers(at)lists(dot)postgresql(dot)org
Subject: pgsql: Hide other user's pg_stat_ssl rows
Date: 2019-02-21 18:55:06
Message-ID: E1gwtUw-0001MI-Ka@gemulon.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-committers

Hide other user's pg_stat_ssl rows

Change pg_stat_ssl so that an unprivileged user can only see their own
rows; other rows will be all null. This makes the behavior consistent
with pg_stat_activity, where information about where the connection
came from is also restricted.

Reviewed-by: Michael Paquier <michael(at)paquier(dot)xyz>
Discussion: https://www.postgresql.org/message-id/flat/63117976-d02c-c8e2-3aef-caa31a5ab8d3%402ndquadrant.com

Branch
------
master

Details
-------
https://git.postgresql.org/pg/commitdiff/f9692a769b16f53be80f819fa5ee91e28dc7683a

Modified Files
--------------
src/backend/utils/adt/pgstatfuncs.c | 73 +++++++++++++++++++++----------------
1 file changed, 41 insertions(+), 32 deletions(-)

Browse pgsql-committers by date

  From Date Subject
Next Message Tom Lane 2019-02-21 19:59:23 pgsql: Move estimate_hashagg_tablesize to selfuncs.c, and widen result
Previous Message Peter Eisentraut 2019-02-21 18:01:11 pgsql: pg_regress: Don't use absolute paths for the diff