[Qgis-user] Primer about user management btw Postgis and QGIS

[Saulteau Don]

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, <bill at williamson.fm> 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
> Qgis-user at lists.osgeo.org
> List info: https://lists.osgeo.org/mailman/listinfo/qgis-user
> Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200422/aead17a7/attachment.html>