Ensure that at a minimum you have, CONNECT for the database
USAGE of the schema SELECT for the table SELECT, USAGE on the sequence(s) for that table On Wed., Apr. 22, 2020, 14:08 Bill Williamson, <[email protected]> wrote: > Hello QGIS workers, > > Could I ask if there is a guide to managing user's accessing of Postgis > data via QGIS? > I can successfully create and access new tables and schema as my own user > (not postgres). Then I use PGAdmin4 to create a new user (I test the login, > OK) and the grant wizard to give ALL to the new user, on the db, the > schema, and for surety the table. > > But this new user cannot see the tables in QGIS (but can login and see the > schema). > PGAdmin4 Properties advises the privileges are in place. > > I don't see that I can readily manage user access out of DBManager in > QGIS, or should I? > > Snip of SQL from PGAdmin; > > ALTER TABLE cadastre.bounds > OWNER to me; > GRANT ALL ON TABLE cadastre.bounds TO "User1"; > GRANT ALL ON TABLE cadastre.bounds TO me; > > regards > bjw > _______________________________________________ > Qgis-user mailing list > [email protected] > List info: https://lists.osgeo.org/mailman/listinfo/qgis-user > Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
_______________________________________________ Qgis-user mailing list [email protected] List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
