On Wed, 20 Nov 2019 at 13:24, Andreas Neumann <a.neum...@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-e...@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-boun...@lists.osgeo.org> För Hernán De Angelis > Skickat: den 20 november 2019 11:10 > Till: qgis-user <qgis-user@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@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@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@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@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@lists.osgeo.org List info: https://lists.osgeo.org/mailman/listinfo/qgis-user Unsubscribe: https://lists.osgeo.org/mailman/listinfo/qgis-user