Document that GRANT on a table does not affect sequence permissions,

bmomjian · bmomjian · commit 99b384b8b6f8 · 2006-02-14T03:32:14.000Z
inclusing SERIAL column sequences.
diff --git a/doc/src/sgml/ref/grant.sgml b/doc/src/sgml/ref/grant.sgml
@@ -1,5 +1,5 @@
 <!--
-$PostgreSQL: pgsql/doc/src/sgml/ref/grant.sgml,v 1.51 2006/01/21 02:16:18 momjian Exp $
+$PostgreSQL: pgsql/doc/src/sgml/ref/grant.sgml,v 1.52 2006/02/14 03:32:14 momjian Exp $
 PostgreSQL documentation
 -->
 
@@ -375,6 +375,13 @@ GRANT <replaceable class="PARAMETER">role</replaceable> [, ...]
     specific role you want to do the <command>GRANT</> as.
    </para>
 
+   <para>
+    Granting permission on a table does not automatically extend 
+    permissions to any sequences used by the table, including 
+    sequences tied to <type>SERIAL</> columns.  Permissions on 
+    sequence must be set separately.
+   </para>
+
    <para>
     Currently, <productname>PostgreSQL</productname> does not support
     granting or revoking privileges for individual columns of a table.
