Add documentation to 'createuser' that ALTER USER must be used to add or

modify passwords, per user confusion report.

Also clean up wording that command line utils need database access.

4 files changed, 26 insertions, 21 deletions

diff --git a/doc/src/sgml/ref/createdb.sgml b/doc/src/sgml/ref/createdb.sgml
index c202c52c12b..0ad159842a3 100644
--- a/doc/src/sgml/ref/createdb.sgml
+++ b/doc/src/sgml/ref/createdb.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/createdb.sgml,v 1.32 2003/03/24 14:32:51 petere Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/createdb.sgml,v 1.33 2003/05/26 17:50:09 momjian Exp $
 PostgreSQL documentation
 -->
 
@@ -44,11 +44,11 @@ PostgreSQL documentation
   <para>
    <application>createdb</application> is a wrapper around the
    <acronym>SQL</acronym> command <xref linkend="SQL-CREATEDATABASE"
-   endterm="SQL-CREATEDATABASE-title">.  Thus, there is nothing
-   special about creating databases via this or other methods.  This
-   means that a database server must be running at the targeted
-   host. Also, any default settings and environment variables used by
-   the <application>libpq</application> front-end library will apply.
+   endterm="SQL-CREATEDATABASE-title">.  The database server must be 
+   running on the targeted host. There is nothing special about creating 
+   databases via this or other methods.  Also, any default settings and 
+   environment variables used by the <application>libpq</application> 
+   front-end library will apply.
   </para>
  </refsect1>
 
diff --git a/doc/src/sgml/ref/createuser.sgml b/doc/src/sgml/ref/createuser.sgml
index eeafdb944f4..13ba5a6fedb 100644
--- a/doc/src/sgml/ref/createuser.sgml
+++ b/doc/src/sgml/ref/createuser.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/createuser.sgml,v 1.32 2003/03/24 14:32:51 petere Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/createuser.sgml,v 1.33 2003/05/26 17:50:09 momjian Exp $
 PostgreSQL documentation
 -->
 
@@ -45,13 +45,19 @@ PostgreSQL documentation
   <para>
    <application>createuser</application> is a wrapper around the
    <acronym>SQL</acronym> command <xref linkend="SQL-CREATEUSER"
-   endterm="SQL-CREATEUSER-title">.  Thus, there is nothing special
-   about creating users via this or other methods. This means that a
-   database server must be running at the targeted host. Also, any
+   endterm="SQL-CREATEUSER-title">.  The database server must be 
+   running on the targeted host. There is nothing special
+   about creating users via this or other methods. Also, any
    default settings and environment variables used by the
    <application>libpq</application> front-end library will apply.
   </para>
 
+  <para>
+   Passwords can only be added later, changed, or removed using the
+   <acronym>SQL</acronym> command <xref linkend="SQL-ALTERUSER" 
+   endterm="SQL-ALTERUSER-title">.
+  </para>
+
  </refsect1>
 
 
diff --git a/doc/src/sgml/ref/dropdb.sgml b/doc/src/sgml/ref/dropdb.sgml
index 107718d5aca..e029b1a6a36 100644
--- a/doc/src/sgml/ref/dropdb.sgml
+++ b/doc/src/sgml/ref/dropdb.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/dropdb.sgml,v 1.21 2003/03/24 14:32:51 petere Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/dropdb.sgml,v 1.22 2003/05/26 17:50:09 momjian Exp $
 PostgreSQL documentation
 -->
 
@@ -37,11 +37,11 @@ PostgreSQL documentation
   <para>
    <application>dropdb</application> is a wrapper around the
    <acronym>SQL</acronym> command <xref linkend="SQL-DROPDATABASE"
-   endterm="SQL-DROPDATABASE-title">.  Thus, there is nothing special
-   about dropping databases via this or other methods. This means that
-   a database server is running at the targeted host. Also, any
+   endterm="SQL-DROPDATABASE-title">.  The database server must be 
+   running on the targeted host. There is nothing special
+   about dropping databases via this or other methods. Also, any
    default settings and environment variables used by the
-   <application>libpq</application> front-end library do apply.
+   <application>libpq</application> front-end library will apply.
   </para>
  </refsect1>
 
diff --git a/doc/src/sgml/ref/dropuser.sgml b/doc/src/sgml/ref/dropuser.sgml
index 67536993e56..d781b2a64f1 100644
--- a/doc/src/sgml/ref/dropuser.sgml
+++ b/doc/src/sgml/ref/dropuser.sgml
@@ -1,5 +1,5 @@
 <!--
-$Header: /cvsroot/pgsql/doc/src/sgml/ref/dropuser.sgml,v 1.24 2003/03/24 14:32:51 petere Exp $
+$Header: /cvsroot/pgsql/doc/src/sgml/ref/dropuser.sgml,v 1.25 2003/05/26 17:50:09 momjian Exp $
 PostgreSQL documentation
 -->
 
@@ -39,12 +39,11 @@ PostgreSQL documentation
   <para>
    <application>dropuser</application> is a shell script wrapper
    around the <acronym>SQL</acronym> command <xref
-   linkend="SQL-DROPUSER" endterm="SQL-DROPUSER-title">.  Thus, there
+   linkend="SQL-DROPUSER" endterm="SQL-DROPUSER-title">.  The database 
+   server must be running on the targeted host. There
    is nothing special about removing users via this or other
-   methods. This means that a database server is running at the
-   targeted host. Also, any default settings and environment variables
-   used by the <application>libpq</application> front-end library do
-   apply.
+   methods. Also, any default settings and environment variables
+   used by the <application>libpq</application> front-end library will apply.
   </para>
  </refsect1>