Deleting postgresql user will not revoke rights to tables

[kjg]

When using "cPanel - PostgreSQL Databases" to create and add a user to a postgresql database, that user will automatically be granted all permissions.

I did not want that for this new user.
So I deleted the user from the database via "cPanel - PostgreSQL Databases", but the user still has all the rights to each database table, view etc

Deleting the user entirely via "cPanel - PostgreSQL Databases"did not help either. The user still has all rights to each database table, view etc.

This is not what I read from:
PostgreSQL Databases

Any ideas how to get this to work?

// kjg

 

[cPanelTristan]

Just to clarify, the postgres database user was deleted but still exists as a user in postgres?

 

[kjg]

Just to clarify, the postgres database user was deleted but still exists as a user in postgres?

Yes, the postgres database user that I earlier created and added to the database via "cPanel - PostgreSQL Databases" still was granted all rights to all tables, views etc after I deleted the user via "cPanel - PostgreSQL Databases"

Using the deleted user on all tables worked fine.

I solved it by revoking the user on all tables, views and sequenses, but the revoke should be automatic on users that are deleted from the database.

 

[cPanelTristan]

Could you please submit a bug report about this issue using http://go.cpanel.net/bugs or using the link at the top of this forum? Any bugs must be reported using that interface and this sounds like an issue to me that a deleted user was still able to access databases.

 

[kjg]

Bug reported.