Removing user access permissions from PostgreSQL database
For safety precaution and to protect your data, database users and users access permissions to databases must kept in a clean and update manner, users that no longer allow to access granted database access must be removed immediately, this is to avoid your important data is kept to minimum risk at all time.
To remove user access permissions from a PostgreSQL database:
Click into PostgreSQL databases in your website hosting account control panel.
In the Databases section, click Delete button beside the user name under the database name you are revoking access.