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

FreeBSD Manual Pages

  
 
  

home | help
ALTER USER(7)		 PostgreSQL 17.5 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 17.5			     2025			 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+14.3.quarterly>

home | help