How to Revoke super user privileges from a Redshift database user

You can revoke the super user privileges previously granted to a database user by running the below sql command where username is the name of the user.

alter user username nocreateuser;
commit;                          

See also  How to get all the currently running queries in Redshift