ALTER USER

Synopsis

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


option
´Â ´ÙÀ½°ú °°½À´Ï´Ù.
    
      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 
configuration_parameter
 { TO | = } { 
value
 | DEFAULT }
ALTER USER 
name
 RESET 
configuration_parameter