How to grant super user privileges to a Redshift database user

To grant super user privileges to an existing database user, login as a super user (master user created during the creation of Redshift cluster is a super user) and run the below sql statement where username is the name of the user.

alter user username createuser;
commit;                        

You can also grant super user privileges during user creation as below:

CREATE USER username PASSWORD 'password' CREATEUSER;