alter_user man page on BSDi

Man page or keyword search:  
man Server   6284 pages
apropos Keyword Search (all sections)
Output format
BSDi logo
[printable version]

ALTER USER()			 SQL Commands			  ALTER USER()

NAME
       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 permitted to cre‐
	      ate  new	users  himself.	 This option will also make the user a
	      superuser who can override all access restrictions.

       abstime
	      The date (and, optionally, the time) at which this user's	 pass‐
	      word 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. Ordinary users can only change their  own
       password.

       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.

SQL - Language Statements	 29 March 2001			  ALTER USER()
[top]

List of man pages available for BSDi

Copyright (c) for man pages and the logo by the respective OS vendor.

For those who want to learn more, the polarhome community provides shell access and support.

[legal] [privacy] [GNU] [policy] [cookies] [netiquette] [sponsors] [FAQ]
Tweet
Polarhome, production since 1999.
Member of Polarhome portal.
Based on Fawad Halim's script.
....................................................................
Vote for polarhome
Free Shell Accounts :: the biggest list on the net