Difference between revisions of "ALTER USER"

From wikieduonline
Jump to navigation Jump to search
Tags: Mobile web edit, Mobile edit
 
(13 intermediate revisions by 2 users not shown)
Line 1: Line 1:
 +
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 WITH PASSWORD 'your_new_password';
+
  [[ALTER USER]] "[[YOUR_USER]]" [[CREATEDB]];
  ALTER_ROLE
+
 
 +
[[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==
+
== Related terms ==
*<code>[[ALTER DATABASE]]</code>
+
* <code>[[ALTER DATABASE]]</code>
*<code>[[CREATE ROLE]]</code>
+
* <code>[[CREATE ROLE]]</code>
*<code>[[CREATE USER]]</code>
+
* <code>[[CREATE USER]]</code>
 
* <code>[[passwd]]</code>
 
* <code>[[passwd]]</code>
 +
* <code>[[\du]]</code>
  
 
== See also ==
 
== See also ==
* {{PostgreSQL}}
+
* {{ALTER}}
 +
* {{Role}}
 +
* {{GRANT}}
  
 
[[Category:PostgreSQL]]
 
[[Category:PostgreSQL]]

Latest revision as of 11:28, 8 February 2023

Advertising: