postgres.git / summary / log / commit / refs

commit    8e78f0a159bc43e2c1eb8b9597d59bc6c154467b
Author:   Bruce Momjian <bruce@momjian.us>
Date:     Tue Oct 10 20:44:02 2023 +0000
First released in: 17.0

    doc:  Move CREATE ROLE's IN GROUP and USER to deprecated
    
    Reported-by: t.kitynski@gmail.com
    
    Discussion: https://postgr.es/m/167473556945.2667294.2003897901995802549@wrigleys.postgresql.org
    
    Backpatch-through: master


 doc/src/sgml/ref/create_role.sgml | 37 ++++++++++++++++---------------------
 1 file changed, 16 insertions(+), 21 deletions(-)

diff --git a/doc/src/sgml/ref/create_role.sgml b/doc/src/sgml/ref/create_role.sgml
index 7249fc74324..8dd2a6395c4 100644
--- a/doc/src/sgml/ref/create_role.sgml
+++ b/doc/src/sgml/ref/create_role.sgml
@@ -36,10 +36,8 @@ CREATE ROLE <replaceable class="parameter">name</replaceable> [ [ WITH ] <replac
     | [ ENCRYPTED ] PASSWORD '<replaceable class="parameter">password</replaceable>' | PASSWORD NULL
     | VALID UNTIL '<replaceable class="parameter">timestamp</replaceable>'
     | IN ROLE <replaceable class="parameter">role_name</replaceable> [, ...]
-    | IN GROUP <replaceable class="parameter">role_name</replaceable> [, ...]
     | ROLE <replaceable class="parameter">role_name</replaceable> [, ...]
     | ADMIN <replaceable class="parameter">role_name</replaceable> [, ...]
-    | USER <replaceable class="parameter">role_name</replaceable> [, ...]
     | SYSID <replaceable class="parameter">uid</replaceable>
 </synopsis>
  </refsynopsisdiv>
@@ -294,15 +292,6 @@ in sync when changing the above synopsis!
       </listitem>
      </varlistentry>
 
-     <varlistentry>
-      <term><literal>IN GROUP</literal> <replaceable class="parameter">role_name</replaceable></term>
-      <listitem>
-       <para><literal>IN GROUP</literal> is an obsolete spelling of
-        <literal>IN ROLE</literal>.
-       </para>
-      </listitem>
-     </varlistentry>
-
      <varlistentry>
       <term><literal>ROLE</literal> <replaceable class="parameter">role_name</replaceable></term>
       <listitem>
@@ -326,16 +315,6 @@ in sync when changing the above synopsis!
       </listitem>
      </varlistentry>
 
-     <varlistentry>
-      <term><literal>USER</literal> <replaceable class="parameter">role_name</replaceable></term>
-      <listitem>
-       <para>
-        The <literal>USER</literal> clause is an obsolete spelling of
-        the <literal>ROLE</literal> clause.
-       </para>
-      </listitem>
-     </varlistentry>
-
      <varlistentry>
       <term><literal>SYSID</literal> <replaceable class="parameter">uid</replaceable></term>
       <listitem>
@@ -484,6 +463,22 @@ CREATE ROLE <replaceable class="parameter">name</replaceable> [ WITH ADMIN <repl
    by giving users the <literal>NOINHERIT</literal> attribute, while roles are
    given the <literal>INHERIT</literal> attribute.
   </para>
+
+  <para>
+   The <literal>USER</literal> clause has the same behavior as
+   <literal>ROLE</literal> but has been deprecated:
+<synopsis>
+USER <replaceable class="parameter">role_name</replaceable> [, ...]
+</synopsis>
+  </para>
+
+  <para>
+   The <literal>IN GROUP</literal> clause has the same behavior as <literal>IN
+   ROLE</literal> but has been deprecated:
+<synopsis>
+IN GROUP <replaceable class="parameter">role_name</replaceable> [, ...]
+</synopsis>
+  </para>
  </refsect1>
 
  <refsect1>


[parent: 914599e56996]