GRANT rds superuser TO "your username";

GRANT rds_superuser TO "your username";

ALTER USER myuser WITH SUPERUSER;
GRANT "your-defined role" TO "your username";
DROP DATABASE

See also

• GRANT, \ddp, GRANT USAGE, GRANT ALL PRIVILEGES, GRANT SELECT, View GRANTs on Redshift, has_table_privilege, has_schema_privilege, HAS_DATABASE_PRIVILEGE, SCHEMA, Privileges, GRANT EXECUTE