postgres.git / summary / log / commit / refs

commit    bae875d694d61b1627eaa6aafbcb2d5460f2dc9d
Author:   Tom Lane <tgl@sss.pgh.pa.us>
Date:     Wed Aug 07 22:09:28 2019 +0000
First released in: 13.0, 9.4.25, 9.5.20, 9.6.16, 10.11, 11.6, 12.0

    Doc: document permissions required for ANALYZE.
    
    VACUUM's reference page had this text, but ANALYZE's didn't.  That's
    a clear oversight given that section 5.7 explicitly delegates the
    responsibility to define permissions requirements to the individual
    commands' man pages.
    
    Per gripe from Isaac Morland.  Back-patch to all supported branches.
    
    Discussion: https://postgr.es/m/CAMsGm5fp3oBUs-2iRfii0iEO=fZuJALVyM2zJLhNTjG34gpAVQ@mail.gmail.com


 doc/src/sgml/ref/analyze.sgml | 10 ++++++++++
 1 file changed, 10 insertions(+)

diff --git a/doc/src/sgml/ref/analyze.sgml b/doc/src/sgml/ref/analyze.sgml
index 27ab4fca42c..f057341a079 100644
--- a/doc/src/sgml/ref/analyze.sgml
+++ b/doc/src/sgml/ref/analyze.sgml
@@ -93,6 +93,16 @@ ANALYZE [ VERBOSE ] [ <replaceable class="PARAMETER">table_name</replaceable> [
  <refsect1>
   <title>Notes</title>
 
+  <para>
+   To analyze a table, one must ordinarily be the table's owner or a
+   superuser.  However, database owners are allowed to
+   analyze all tables in their databases, except shared catalogs.
+   (The restriction for shared catalogs means that a true database-wide
+   <command>ANALYZE</command> can only be performed by a superuser.)
+   <command>ANALYZE</command> will skip over any tables that the calling user
+   does not have permission to analyze.
+  </para>
+
   <para>
    Foreign tables are analyzed only when explicitly selected.  Not all
    foreign data wrappers support <command>ANALYZE</>.  If the table's


[parent: fd298cd6394b]