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

[Jorge Gustavo Rocha]

Please use pg_services. No Auth is stored. Just the service name. -+-+-+-+-+-+-+-+-+-Geomaster, LdaRua Afonso Palmeira, 31, 7 D4715-278 BragaNIF 510906109Tm +351 910333888Email jgr at geomaster.ptSent 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? CliffOn 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. 2616www.psdrcs.comLondon | 148 Fullarton St. 9th Floor         
-- Cliff Patterson Ph.D.PSD | Senior GIS Consultant P: 519-690-2565 ext. 2616www.psdrcs.comLondon | 148 Fullarton St. 9th Floor         
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/qgis-user/attachments/20200529/24530839/attachment.html>