Difference between revisions of "ALTER USER"
Jump to navigation
Jump to search
| (One intermediate revision by one other user not shown) | |||
| Line 8: | Line 8: | ||
Error: must be [[superuser]] to alter superusers | 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 == | == Related terms == | ||
Latest revision as of 11:28, 8 February 2023
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 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
Advertising:
