Difference between revisions of "ALTER USER"

From wikieduonline
Jump to navigation Jump to search
 
(5 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
  
 +
[[ALTER USER airflow_user [[SET]] [[search_path]] = [[public]];
 +
 +
[[ALTER]] USER prometheus [[SET]] SEARCH_PATH TO prometheus,[[pg_catalog]];
  
 
== Related terms ==
 
== Related terms ==
Line 16: Line 20:
  
 
== See also ==
 
== See also ==
 +
* {{ALTER}}
 
* {{Role}}
 
* {{Role}}
* {{PostgreSQL}}
+
* {{GRANT}}
  
 
[[Category:PostgreSQL]]
 
[[Category:PostgreSQL]]

Latest revision as of 11:28, 8 February 2023

Advertising: