ALTER USER - Modifies user account information


SYNOPSIS

       ALTER USER username
           [ WITH PASSWORD 'password' ]
           [ CREATEDB | NOCREATEDB ] [ CREATEUSER | NOCREATEUSER ]
           [ VALID UNTIL 'abstime' ]

   INPUTS
       username
              The  name  of  the  user  whose  details  are to be
              altered.

       password
              The new password to be used for this account.

       CREATEDB

       NOCREATEDB
              These clauses define a  user's  ability  to  create
              databases.   If  CREATEDB  is  specified,  the user
              being defined will be allowed  to  create  his  own
              databases.  Using  NOCREATEDB  will deny a user the
              ability to create databases.

       CREATEUSER

       NOCREATEUSER
              These clauses determine whether a user will be per­
              mitted  to  create  new  users himself. This option
              will also make the user a superuser who  can  over­
              ride all access restrictions.

       abstime
              The  date (and, optionally, the time) at which this
              user's password is to expire.

   OUTPUTS
       ALTER USER
              Message returned if the alteration was  successful.

       ERROR: ALTER USER: user "username" does not exist
              Error message returned if the specified user is not
              known to the database.


DESCRIPTION

       ALTER USER is used to change the attributes  of  a  user's
       Postgres  account.  Only  a  database superuser can change
       privileges and  password  expiration  with  this  command.


       Use  CREATE USER [create_user(l)] to create a new user and
       DROP USER [drop_user(l)] to remove a user.


USAGE

       Change a user password:

       ALTER USER davide WITH PASSWORD 'hu8jmn3';

       Change a user's valid until date:

       ALTER USER manuel VALID UNTIL 'Jan 31 2030';

       Change a user's valid  until  date,  specifying  that  his
       authorization  should  expire  at  midday  on 4th May 1998
       using the time zone which is one hour ahead of UTC:

       ALTER USER chris VALID UNTIL 'May 4 12:00:00 1998 +1';

       Give a user the ability to  create  other  users  and  new
       databases:

       ALTER USER miriam CREATEUSER CREATEDB;


COMPATIBILITY

   SQL92
       There  is  no ALTER USER statement in SQL92.  The standard
       leaves the definition of users to the implementation.


Man(1) output converted with man2html