I have a PostGIS DB with three roles: admin, user and readonly.
When I set up a connection to this database via "Add PostGIS layer" this connection is saved as it should be. So I login as admin to create some tables. I don't save any login informations.
But now I have no possibility to logout and re-login as another user e.g. to check if I set up permissions correctly or whatever.
I tried to reconnect via "Add PostGIS layer" but this has no effect. The only way to do this seems to close QGIS and restart it.
Is there another way to logout and re-login as another user? For now this has to be done using QGIS 2.18.
Figured out I can run 3 instances of QGIS with 3 different login-informations at the same time. Better than restarting, but not the "solution" I was hoping for...