To grant super user privileges to an existing database user, login as a super user and run the below sql statement where username is the name of the user.
alter user username superuser; commit;
You can also grant super user privileges during user creation as below:
CREATE USER username PASSWORD 'password' SUPERUSER;