postgres.git / summary / log / commit / refs

commit    0f53934164d37682fd6a6d87d57008f9ca03e3d0
Author:   Peter Eisentraut <peter_e@gmx.net>
Date:     Thu Nov 02 16:12:23 2017 +0000
First released in: 11.0

    doc: Clarify pgstattuple privileges information
    
    The description has gotten a bit confusing over time, so rewrite the
    paragraph a bit.
    
    Reported-by: Feike Steenbergen <feikesteenbergen@gmail.com>


doc/src/sgml/pgstattuple.sgml | 14 ++++++++------ 1 file changed, 8 insertions(+), 6 deletions(-) diff --git a/doc/src/sgml/pgstattuple.sgml b/doc/src/sgml/pgstattuple.sgml index 611df9d0bfd..04a4423dc54 100644 --- a/doc/src/sgml/pgstattuple.sgml +++ b/doc/src/sgml/pgstattuple.sgml @@ -13,12 +13,14 @@ </para> <para> - As these functions return detailed page-level information, only the superuser - has EXECUTE privileges on them upon installation. After the functions have - been installed, users may issue <command>GRANT</command> commands to change - the privileges on the functions to allow non-superusers to execute them. Members - of the <literal>pg_stat_scan_tables</literal> role are granted access by default. See - the description of the <xref linkend="sql-grant"> command for specifics. + Because these functions return detailed page-level information, access is + restricted by default. By default, only the + role <literal>pg_stat_scan_tables</literal> has <literal>EXECUTE</literal> + privilege. Superusers of course bypass this restriction. After the + extension has been installed, users may issue <command>GRANT</command> + commands to change the privileges on the functions to allow others to + execute them. However, it might be preferable to add those users to + the <literal>pg_stat_scan_tables</literal> role instead. </para> <sect2> [parent: 7b6c07547190]