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...

  • maybe using "changeDataSource" plugin ,look at this gis.stackexchange.com/questions/62610/… – Fran Raga Aug 13 at 9:35
  • you can add another connection as the ReadOnly user and add the layer from this account. The behaviour( not editable for example) is observable – LaughU Aug 13 at 9:51
  • Seems to be logical, but unfortunately this does not work. QGIS recognizes the two connections to the same DB as one somehow. And again only the login information I entered first is used. Therefore also changeDataSource plugin doesn't help, as it is using the connections provided by QGIS. – MrXsquared Aug 13 at 10:47
  • I'm highly interested by the solution you will find ... i always found that's some big issue. Surprised you don't get any answer ... summer time maybe ... lol – snaileater Aug 15 at 9:14

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.