Difference between revisions of "ALTER USER"
Jump to navigation
Jump to search
| (7 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;]] | ||
| + | Error: must be [[superuser]] to alter superusers | ||
| − | ==Related terms== | + | [[ALTER USER airflow_user [[SET]] [[search_path]] = [[public]]; |
| − | *<code>[[ALTER DATABASE]]</code> | + | |
| − | *<code>[[CREATE ROLE]]</code> | + | [[ALTER]] USER prometheus [[SET]] SEARCH_PATH TO prometheus,[[pg_catalog]]; |
| − | *<code>[[CREATE USER]]</code> | + | |
| + | == Related terms == | ||
| + | * <code>[[ALTER DATABASE]]</code> | ||
| + | * <code>[[CREATE ROLE]]</code> | ||
| + | * <code>[[CREATE USER]]</code> | ||
* <code>[[passwd]]</code> | * <code>[[passwd]]</code> | ||
* <code>[[\du]]</code> | * <code>[[\du]]</code> | ||
== See also == | == See also == | ||
| − | * {{ | + | * {{ALTER}} |
| + | * {{Role}} | ||
| + | * {{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:
