Follow Techotopia on Twitter

On-line Guides
All Guides
eBook Store
iOS / Android
Linux for Beginners
Office Productivity
Linux Installation
Linux Security
Linux Utilities
Linux Virtualization
Linux Kernel
System/Network Admin
Programming
Scripting Languages
Development Tools
Web Development
GUI Toolkits/Desktop
Databases
Mail Systems
openSolaris
Eclipse Documentation
Techotopia.com
Virtuatopia.com
Answertopia.com

How To Guides
Virtualization
General System Admin
Linux Security
Linux Filesystems
Web Servers
Graphics & Desktop
PC Hardware
Windows
Problem Solutions
Privacy Policy

  




 

 

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 , 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.


 
 
  Published courtesy of The PostgreSQL Global Development Group Design by Interspire