[Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a multiuser environment?

[Luigi Pirelli]

On Wed, 20 Nov 2019 at 13:24, Andreas Neumann <a.neumann at carto.net> wrote:

> Hi,
>
> I wonder what is best practice to handle auth configs across several users
> for sharing of projects?
>
> Should we ask users to create the same auth-config ids/names to make
> projects interoperable, where each users would have different credentials,
> but share the auth-config id that is stored in the QGIS project file?
>

exactly... authid can be edited => aliñed for a team


> Is this how we should do it? Otherwise users would end up with different
> auth-ids and then can't open QGIS files from their colleagues without a
> hassle ...
>

corret... that's the reason you can set you 7char id!


> Or are there better/alternative approaches?
>
> Andreas
>

share auth.db (or a profile) with credential setup... but you should also
share pwd to de-encrypt authdb. IMHO Better crate each one it's authddb
setting his personal credentials to decrypt and use common authid for
shared projects.

Luigi Pirelli

**************************************************************************************************
* LinkedIn: https://www.linkedin.com/in/luigipirelli
* Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
* GitHub: https://github.com/luipir
* Book: Mastering QGIS3 - 3rd Edition
<https://www.packtpub.com/eu/application-development/mastering-geospatial-development-qgis-3x-third-edition>
* Hire a team: http://www.qcooperative.net
**************************************************************************************************

> On 2019-11-20 13:14, Hernán De Angelis wrote:
>
> Interesting point, Luigi. Thank you!
>
> Hernán
>
>
> On 2019-11-20 12:58, Luigi Pirelli wrote:
>
> this is not an issue, Postgres support many auth systems most of them
> paired with the authentication system implemented in QGIS. Other problem is
> how to share (auth.db) credentials or security setting among different
> users.
>
> Luigi Pirelli
>
>
> **************************************************************************************************
> * LinkedIn: https://www.linkedin.com/in/luigipirelli
> * Stackexchange: http://gis.stackexchange.com/users/19667/luigi-pirelli
> * GitHub: https://github.com/luipir
> * Book: Mastering QGIS3 - 3rd Edition
> <https://www.packtpub.com/eu/application-development/mastering-geospatial-development-qgis-3x-third-edition>
> * Hire a team: http://www.qcooperative.net
>
> **************************************************************************************************
>
> On Wed, 20 Nov 2019 at 11:53, Jan-Eric Oskarsson <jan-eric at kregis.se>
> wrote:
>
> Hi Hernán!
> Maybe this comment is redundant but you have to set up a strong security
> to prevent hackers to hack your database and steal your data and cause
> damage.
> I hope uthat you already have thought about this issu!
>
> Kind Regards
> Jan-Eric
>
> -----Ursprungligt meddelande-----
> Från: Qgis-user <qgis-user-bounces at lists.osgeo.org> För Hernán De Angelis
> Skickat: den 20 november 2019 11:10
> Till: qgis-user <qgis-user at lists.osgeo.org>
> Ämne: [Qgis-user] Experiences using QGIS + PostgreSQL/PostGIS in a
> multiuser environment?
>
> Hello QGIS:ers
>
> I am evaluating setting up a server running PostgreSQL/PostGIS for use as
> data sharing/collaborating environment for spatial data. The user group may
> consist of up to 15 people, mostly using QGIS but one or two may use other
> software (non OS). Data is almost exclusively of vector type. The use is
> within a single organization.
>
> I understand some people in this list have experience with this kind of
> environment and would appreciate if any of you would share any useful
> experience, challenges, thought or things to watch out for. I understand
> basic management routines are critical (user management, user rights), as
> well as a sound backup and update strategy. I also understand that proper
> data management procedures have to be in place, like rules for table
> creation and eventual deletion, attribute selection, etc. But what else can
> go wrong with this kind of setup if not managed properly?
> Thoughts and experiences welcome!
>
> Best regards and thanks in advance
>
> Hernán
>
>
>
>
>
> _______________________________________________
> 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
>
> _______________________________________________
> 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
>
>
> _______________________________________________
> 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
>
>
> _______________________________________________
> 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/20191120/ca85a5ad/attachment.html>