Yolinux.com

alter_user manpage

Search topic Section
Get manual page for the search topic
List all commands matching the search topic
List all topics in the manpage index

ALTER USER()			 SQL Commands			  ALTER USER()



NAME
       ALTER USER - change a database role


SYNOPSIS
       ALTER USER name [ [ WITH ] option [ ... ] ]

       where option can be:

	     SUPERUSER | NOSUPERUSER
	   | CREATEDB | NOCREATEDB
	   | CREATEROLE | NOCREATEROLE
	   | CREATEUSER | NOCREATEUSER
	   | INHERIT | NOINHERIT
	   | LOGIN | NOLOGIN
	   | CONNECTION LIMIT connlimit
	   | [ ENCRYPTED | UNENCRYPTED ] PASSWORD 'password'
	   | VALID UNTIL 'timestamp'

       ALTER USER name RENAME TO newname

       ALTER USER name SET parameter { TO | = } { value | DEFAULT }
       ALTER USER name RESET parameter


DESCRIPTION
       ALTER  USER  is	now an alias for ALTER ROLE [alter_role(7)], which see
       for more information.

COMPATIBILITY
       The ALTER USER statement is a PostgreSQL extension.  The	 SQL  standard
       leaves the definition of users to the implementation.

SEE ALSO
       ALTER ROLE [alter_role(7)]



SQL - Language Statements	  2010-12-14			  ALTER USER()
YoLinux.com Home Page
YoLinux Tutorial Index
Privacy Policy | Advertise with us | Feedback Form |
Unauthorized copying or redistribution prohibited.
    Bookmark and Share