diff options
| -rw-r--r-- | doc/src/sgml/ref/alter_user.sgml | 12 |
1 files changed, 10 insertions, 2 deletions
diff --git a/doc/src/sgml/ref/alter_user.sgml b/doc/src/sgml/ref/alter_user.sgml index e6c5ac54d7a..a37424cd26d 100644 --- a/doc/src/sgml/ref/alter_user.sgml +++ b/doc/src/sgml/ref/alter_user.sgml @@ -1,5 +1,5 @@ <!-- -$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_user.sgml,v 1.24 2003/01/19 00:13:29 momjian Exp $ +$Header: /cvsroot/pgsql/doc/src/sgml/ref/alter_user.sgml,v 1.25 2003/03/20 20:05:32 momjian Exp $ PostgreSQL documentation --> @@ -124,7 +124,8 @@ ALTER USER <replaceable class="PARAMETER">username</replaceable> RESET <replacea <listitem> <para> The date (and, optionally, the time) - at which this user's password is to expire. + at which this user's password is to expire. To set the password + never to expire, use 'infinity'. </para> </listitem> </varlistentry> @@ -233,6 +234,13 @@ ALTER USER chris VALID UNTIL 'May 4 12:00:00 1998 +1'; </para> <para> + Make a user valid forever: +<programlisting> +ALTER USER fred VALID UNTIL 'infinity'; +</programlisting> + </para> + + <para> Give a user the ability to create other users and new databases: <programlisting> |