Thread: [pgAdmin][Patch] - Bug #6641 - Invalid failure for pgAdmin terminate session for AWS RDS Postgres.

Hi,

Attached patch enables pgadmin to retrieve user permissions in case of nested roles.

 

Steps to Tests - 

1.Create a new role 'parent' with pg_signal_backend() access.

2.Create a new role 'child' & add as Member of 'parent' role.

3.Create new role 'test' (not a superuser) & connect with this role.

4.Now connect to server with 'child' role using pgAdmin & try to terminate connection create with by user 'test'

5.User should be able to terminate connection successfully.

Thanks,

Yogesh Mahajan

EnterpriseDB