Difference between revisions of "ALTER USER"
Jump to navigation
Jump to search
| (3 intermediate revisions by one other user not shown) | |||
| Line 3: | Line 3: | ||
ALTER_ROLE | ALTER_ROLE | ||
| − | [[ALTER USER]] "[[YOUR_USER]]" CREATEDB; | + | [[ALTER USER]] "[[YOUR_USER]]" [[CREATEDB]]; |
[[ALTER USER myuser WITH SUPERUSER;]] | [[ALTER USER myuser WITH SUPERUSER;]] | ||
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 == | ||
| Line 17: | Line 20: | ||
== See also == | == See also == | ||
| + | * {{ALTER}} | ||
* {{Role}} | * {{Role}} | ||
* {{GRANT}} | * {{GRANT}} | ||
[[Category:PostgreSQL]] | [[Category:PostgreSQL]] | ||
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:
