Skip site navigation (1)Skip section navigation (2)

  
 
  

home | help 
ALTER USER(7)		  PostgreSQL 18.6 Documentation 	   ALTER USER(7)

NAME
     ALTER_USER - change a database role

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

     where option can be:

	   SUPERUSER | NOSUPERUSER
	 | CREATEDB | NOCREATEDB
	 | CREATEROLE | NOCREATEROLE
	 | INHERIT | NOINHERIT
	 | LOGIN | NOLOGIN
	 | REPLICATION | NOREPLICATION
	 | BYPASSRLS | NOBYPASSRLS
	 | CONNECTION LIMIT connlimit
	 | [ ENCRYPTED ] PASSWORD 'password' | PASSWORD NULL
	 | VALID UNTIL 'timestamp'

     ALTER USER name RENAME TO new_name

     ALTER USER { role_specification | ALL } [ IN DATABASE database_name ] SET configuration_parameter { TO | = } { value | DEFAULT }
     ALTER USER { role_specification | ALL } [ IN DATABASE database_name ] SET configuration_parameter FROM CURRENT
     ALTER USER { role_specification | ALL } [ IN DATABASE database_name ] RESET configuration_parameter
     ALTER USER { role_specification | ALL } [ IN DATABASE database_name ] RESET ALL

     where role_specification can be:

	 role_name
       | CURRENT_ROLE
       | CURRENT_USER
       | SESSION_USER

DESCRIPTION
     ALTER USER is now an alias for ALTER ROLE.

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))

PostgreSQL 18.6 		      2026			   ALTER USER(7)

Want to link to this manual page? Use this URL:
<https://man.freebsd.org/cgi/man.cgi?query=ALTER_USER&sektion=7&manpath=FreeBSD+Ports+15.1.quarterly>

home | help