[Qgis-user] Save projects to DB without creator's permissions

[Cliff Patterson]

Interesting, Jorge. Thanks

Cliff

On Fri, May 29, 2020 at 2:35 PM Jorge Gustavo Rocha <jgr at geomaster.pt>
wrote:

> Please use pg_services. No Auth is stored. Just the service name.
>
> -+-+-+-+-+-+-+-+-+-
> Geomaster, Lda
> Rua Afonso Palmeira, 31, 7 D
> 4715-278 Braga
> NIF 510906109
>
> Tm +351 910333888 <+351%20910333888>
> Email jgr at geomaster.pt
>
> Sent from my mobile. Please excuse the brevity, spelling and punctuation.
>
>
> -------- Mensagem original --------
> De : Cliff Patterson <cpatterson at psdrcs.com>
> Data: 29/05/20 18:39 (GMT+00:00)
> Para: qgis-user <qgis-user at lists.osgeo.org>
> Assunto: Re: [Qgis-user] Save projects to DB without creator's permissions
>
> PS: I realize I can create maps with basic auth and not store the PW,
> which prompts the user to enter their creds. But is there a better way now
> to achieve the same result?
>
> Cliff
>
> On Fri, May 29, 2020 at 1:29 PM Cliff Patterson <cpatterson at psdrcs.com>
> wrote:
>
>> What is the best approach to save QGIS projects to PostgreSQL
>> without saving the project-creator's credentials/permissions? If the DB
>> admin creates a project and saves it to the DB, anyone opening that project
>> will attain the admin's permissions on layers in that map.
>>
>> To recreate:
>>
>> 1) Create a map containing PostGIS layers and save project to DB. All
>> layers should be editable by the admin. Admin is logged into DB with auth
>> config, not basic auth.
>> 2) Create a new read-only user and new profile in QGIS and log in to DB.
>> 3) Open the project and try to edit layers. Read-only user will be able
>> to see and edit all layers just like the DB Admin.
>>
>> Is there a way to save projects to DB WITHOUT saving any user
>> creds/permissions?
>>
>> Cliff
>>
>> --
>>
>> Cliff Patterson Ph.D.
>>
>> *PSD* | Senior GIS Consultant
>> P: 519-690-2565 ext. 2616
>> www.psdrcs.com
>> London | 148 Fullarton St. 9th Floor
>>
>>
>
> --
>
> Cliff Patterson Ph.D.
>
> *PSD* | Senior GIS Consultant
> P: 519-690-2565 ext. 2616
> www.psdrcs.com
> London | 148 Fullarton St. 9th Floor
>
>

-- 

Cliff Patterson Ph.D.

*PSD* | Senior GIS Consultant
P: 519-690-2565 ext. 2616
www.psdrcs.com
London | 148 Fullarton St. 9th Floor
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200529/0f0755e1/attachment.html>