<html><head></head><body><div style="color:#000; background-color:#fff; font-family:HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif;font-size:13px"><div id="yui_3_16_0_ym19_1_1489802750574_7804"><span>Hi Yves,</span></div><div id="yui_3_16_0_ym19_1_1489802750574_7852"><span><br></span></div><div id="yui_3_16_0_ym19_1_1489802750574_7825" dir="ltr">Thanks for your response. I have been able to solve the mystery.
The problem was from QGIS as suspected. When you create the first user
connection to the database (PostgreSQL/PostGIS in this case) and you add
a new connection with a different user or edit the first connection to a
different user without restarting the application, QGIS uses the
privileges of the first user connection for the new user connection (the
privileges can be viewed from the Database Manager menu). This is
likely a <b id="yui_3_16_0_ym19_1_1489802750574_7838">bug</b> in the QGIS software as <b id="yui_3_16_0_ym19_1_1489802750574_7839">refreshing the edited connection or deleting the connection and creating a new one makes no difference</b>. <br id="yui_3_16_0_ym19_1_1489802750574_7840"><br id="yui_3_16_0_ym19_1_1489802750574_7841">The only way I have found around this "bug" is to <b id="yui_3_16_0_ym19_1_1489802750574_7842">restart the QGIS application before creating a new user connection or editing a connection to a different user</b>.<br id="yui_3_16_0_ym19_1_1489802750574_7843"></div><div class="qtdSeparateBR" id="yui_3_16_0_ym19_1_1489802750574_7805"><br><br></div><div class="yahoo_quoted" id="yui_3_16_0_ym19_1_1489802750574_7759" style="display: block;"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 13px;" id="yui_3_16_0_ym19_1_1489802750574_7758"> <div style="font-family: HelveticaNeue, Helvetica Neue, Helvetica, Arial, Lucida Grande, sans-serif; font-size: 16px;" id="yui_3_16_0_ym19_1_1489802750574_7757"> <div dir="ltr" id="yui_3_16_0_ym19_1_1489802750574_7756"> <font id="yui_3_16_0_ym19_1_1489802750574_7760" face="Arial" size="2"> <hr id="yui_3_16_0_ym19_1_1489802750574_7844" size="1"> <b><span style="font-weight:bold;">From:</span></b> Yves Jacolin <yjacolin@free.fr><br> <b><span style="font-weight: bold;">To:</span></b> qgis-community-team@lists.osgeo.org; Oduware Godwin Osahon <victoryaceta@yahoo.com> <br> <b><span style="font-weight: bold;">Sent:</span></b> Friday, March 17, 2017 4:59 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> Re: [Qgis-community-team] [URGENT!] QGIS Seem To Bypass PostgreSQL/PostGIS User Privileges/Permissions<br> </font> </div> <div class="y_msg_container" id="yui_3_16_0_ym19_1_1489802750574_7763"><br><div dir="ltr" id="yui_3_16_0_ym19_1_1489802750574_7762">Hello,<br clear="none"><br clear="none">On vendredi 17 mars 2017 14:18:36 CET Oduware Godwin Osahon wrote:<br clear="none">> QGIS is bypassing the permissions set for the same user in the<br clear="none">> PostgreSQL/PostGIS database<br clear="none"><br clear="none">This is not possible, imho. This is not QGIS that protects the edition process <br clear="none">into your table but PostGreSQL itself.<br clear="none"><br clear="none">Did you check that the user is really correct?<br clear="none">Did you check that your credential are still valid when working in QGIS <br clear="none">(something like transaction or so)?<br clear="none"><br clear="none">As far as I know this issue never occurs in my PostGIS training (I am using <br clear="none">QGIS as viewer for SQL results).<div class="yqt0852515075" id="yqtfd86731"><br clear="none"><br clear="none">Y.</div></div><br><br></div> </div> </div> </div></div></body></html>