ALTER USER

https://www.postgresql.org/docs/8.0/sql-alteruser.html
ALTER USER YOUR_USER WITH PASSWORD 'your_new_password';
ALTER_ROLE

ALTER USER "YOUR_USER" CREATEDB;

ALTER USER myuser WITH SUPERUSER;
Error: must be superuser to alter superusers

[[ALTER USER airflow_user SET search_path = public;

ALTER USER prometheus SET SEARCH_PATH TO prometheus,pg_catalog;

Related terms

• ALTER DATABASE
• CREATE ROLE
• CREATE USER
• passwd
• \du

See also

• ALTER, ALTER DATABASE, ALTER TABLE, ALTER DEFAULT PRIVILEGES, ALTER MATERIALIZED VIEW
• PostgreSQL: Database roles, CREATE USER, CREATE ROLE, \du, \du+, create user, Alter user
• GRANT, \ddp, GRANT USAGE, GRANT ALL PRIVILEGES, GRANT SELECT, View GRANTs on Redshift, has_table_privilege, has_schema_privilege, HAS_DATABASE_PRIVILEGE, SCHEMA, Privileges, GRANT EXECUTE