Remove PostgreSQL database user
When you are disallowing acess from a particular PostgreSQL database user to your database server, you should remove the database user completely from the database server to prevent any security issues that lead to damages to your important data.
To remove a database user:
Select the PostgreSQL databases in your Cpanel hosting account control panel.
Click Delete button shown beside the database user that you want to delete in the Users section.