diff options
| author | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2008-04-30 12:38:49 +0000 |
|---|---|---|
| committer | Alvaro Herrera <alvherre@alvh.no-ip.org> | 2008-04-30 12:38:49 +0000 |
| commit | ca0aecfdefbca04f2a6ed05044f9cafc3605389f (patch) | |
| tree | 814de8747d1499213601b9284d65c93fbcd5aa7f | |
| parent | c0cf5c37cd273995268e8c16e90e816a66474ddd (diff) | |
| download | postgresql-ca0aecfdefbca04f2a6ed05044f9cafc3605389f.tar.gz postgresql-ca0aecfdefbca04f2a6ed05044f9cafc3605389f.zip | |
Add example showing how to remove a password from a role.
Andreas Scherbaum
| -rw-r--r-- | doc/src/sgml/ref/alter_role.sgml | 10 |
1 files changed, 9 insertions, 1 deletions
diff --git a/doc/src/sgml/ref/alter_role.sgml b/doc/src/sgml/ref/alter_role.sgml index a471095e496..069d81bbcd8 100644 --- a/doc/src/sgml/ref/alter_role.sgml +++ b/doc/src/sgml/ref/alter_role.sgml @@ -1,5 +1,5 @@ <!-- -$PostgreSQL: pgsql/doc/src/sgml/ref/alter_role.sgml,v 1.9 2007/09/03 18:46:29 tgl Exp $ +$PostgreSQL: pgsql/doc/src/sgml/ref/alter_role.sgml,v 1.10 2008/04/30 12:38:49 alvherre Exp $ PostgreSQL documentation --> @@ -218,6 +218,14 @@ ALTER ROLE davide WITH PASSWORD 'hu8jmn3'; </para> <para> + Remove a role's password: + +<programlisting> +ALTER ROLE davide WITH PASSWORD NULL; +</programlisting> + </para> + + <para> Change a password expiration date, specifying that the password should expire at midday on 4th May 2015 using the time zone which is one hour ahead of <acronym>UTC</>: |