Difference between revisions of "PostgreSQL superuser"

From wikieduonline
Jump to navigation Jump to search
 
(5 intermediate revisions by 2 users not shown)
Line 17: Line 17:
  
 
== Related ==
 
== Related ==
 +
* [[CREATE ROLE]]
 
* [[PostgreSQL: Database roles]]
 
* [[PostgreSQL: Database roles]]
 
* [[root]]
 
* [[root]]
 +
* <code>[[DROP DATABASE]]</code>
 +
* [[Elasticsearch superuser]]
 +
* [[pg_read_all_settings]] Read all configuration variables, even those normally visible only to superusers.
  
 
== See also ==
 
== See also ==
 
* {{role}}
 
* {{role}}
 +
* {{PosgreSQL users}}
  
 
[[Category:PostgreSQL]]
 
[[Category:PostgreSQL]]

Latest revision as of 15:21, 20 September 2024

Examples[edit]

To grant rds_superuser to a user user:

GRANT rds_superuser TO "your_username";

Output:
GRANT ROLE 


ALTER USER myuser WITH SUPERUSER;
Error: must be superuser to alter superusers


Related[edit]

See also[edit]

Advertising: