Linux Certif

Toute la documentation sur la certification Linux LPI

Rechercher une page de manuel

alter_user

NAME

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 configuration_parameter { TO | = } { value | DEFAULT }
 ALTER USER name RESET configuration_parameter
 
 

DESCRIPTION

ALTER USER is now an alias for ALTER ROLE [alter_role(7)].

COMPATIBILITY

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

SEE ALSO