PostgreSQL – Revoke super user privileges

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 NOSUPERUSER;
commit;
See also  PostgreSQL - Create a Read Only User