Difference between revisions of "PostgreSQL superuser"
Jump to navigation
Jump to search
| (2 intermediate revisions by 2 users not shown) | |||
| Line 21: | Line 21: | ||
* [[root]] | * [[root]] | ||
* <code>[[DROP DATABASE]]</code> | * <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
postgresissuperuserin PostgreSQLrds_superuseris Superuser in AWS RDS PostgreSQL
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]
- CREATE ROLE
- PostgreSQL: Database roles
- root
DROP DATABASE- Elasticsearch superuser
- pg_read_all_settings Read all configuration variables, even those normally visible only to superusers.
See also[edit]
Advertising:
