2

I have established a connection between QGIS and PostgreSQL. As long as the active user has the 'Super User'check-box enabled, all works well. From the moment I disable it only the Schema's remain visible. The layers are gone. I searched the Internet but can't find any solution.

PostgreSQL 11 / PostGIS 2.5 / QGIS 3.4.1 / Windows 10 (home edition)

6

You need to explicitly grant privileges to the user:

GRANT USAGE ON SCHEMA mySchema TO myUser;
GRANT SELECT, INSERT, UPDATE, DELETE ON  mySchema.myTable TO myUser;
  • 1
    Or alternatively to a role to which the user belongs. – jpmc26 Feb 1 at 23:17

Your Answer

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

Not the answer you're looking for? Browse other questions tagged or ask your own question.