Difference between revisions of "PostgreSQL superuser"
Jump to navigation
Jump to search
| (7 intermediate revisions by 2 users not shown) | |||
| Line 2: | Line 2: | ||
* <code>postgres</code> is <code>superuser</code> in [[PostgreSQL]] | * <code>postgres</code> is <code>superuser</code> in [[PostgreSQL]] | ||
* <code>[[rds_superuser]]</code> is Superuser in [[AWS RDS PostgreSQL]] | * <code>[[rds_superuser]]</code> is Superuser in [[AWS RDS PostgreSQL]] | ||
| + | |||
| + | == Examples == | ||
| + | To grant <code>rds_superuser</code> to a user user: | ||
| + | [[GRANT]] rds_superuser TO "[[your_username]]"; | ||
| + | |||
| + | Output: | ||
| + | GRANT ROLE | ||
| + | |||
| + | |||
[[ALTER USER myuser WITH SUPERUSER;]] | [[ALTER USER myuser WITH SUPERUSER;]] | ||
| Line 8: | 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}} |
| + | * {{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:
