ALTER USER
Jump to navigation
Jump to search
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[edit]
See also[edit]
ALTER, ALTER DATABASE, 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
Advertising: