Difference between revisions of "PostgreSQL superuser"

Revision as of 14:48, 18 November 2022

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

@@ Line 2: / Line 2: @@
 * <code>postgres</code> is <code>superuser</code> in [[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;]]