[prev in list] [next in list] [prev in thread] [next in thread] 

List:       qgis-user
Subject:    Re: [Qgis-user] QGIS read-only user
From:       Alexandre Neto <senhor.neto () gmail ! com>
Date:       2021-04-27 8:23:55
Message-ID: CA+H0G_HRnGtxe3Odj-eNUFWji573BiT+P-qom2CAF09-jD=Dag () mail ! gmail ! com
[Download RAW message or body]

[Attachment #2 (multipart/alternative)]


As Jorge says,

If the database table permissions are well configured, the user can't even
click the edit button on QGIS.

Can you share one table SQL information? For example from pgadmin.

Alexandre Neto

A ter=C3=A7a, 27/04/2021, 08:47, Jorge Gustavo Rocha <jgr@geomaster.pt> esc=
reveu:

> Hi Raffaele,
>
> Which database are you using? PostgreSQL?
>
> The database provider does not allow modifications, if the user does not
> have permissions.
>
> Can you confirm that the database changes even if the user does not have
> permission to write?
>
> Regards,
>
> Jorge Gustavo
> On 27/04/21 08:40, Raffaele Ceretto wrote:
>
> Good morning,
>
> I created 2 users on my database.
> one admin and one read-only.
> The read-only one still allows me to edit and delete.
> I get the message "this user does not have the permissions, contact the
> administrator of the database", but does the modification anyway.
> I have tried closing qgis and recreating the connections several times bu=
t
> nothing changes.
> It appears to be bypassing the permissions
> Could you help me?
>
> With best regards
>
> _______________________________________________
> Qgis-user mailing listQgis-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
>

[Attachment #5 (text/html)]

<div dir="auto">As Jorge says,<div dir="auto"><br></div><div dir="auto">If the \
database table permissions are well configured, the user can&#39;t even click the \
edit button on QGIS.</div><div dir="auto"><br></div><div dir="auto">Can you share one \
table SQL information? For example from pgadmin.</div><div dir="auto"><br></div><div \
dir="auto">Alexandre Neto</div></div><br><div class="gmail_quote"><div dir="ltr" \
class="gmail_attr">A terça, 27/04/2021, 08:47, Jorge Gustavo Rocha &lt;<a \
href="mailto:jgr@geomaster.pt">jgr@geomaster.pt</a>&gt; \
escreveu:<br></div><blockquote class="gmail_quote" style="margin:0 0 0 \
.8ex;border-left:1px #ccc solid;padding-left:1ex">  
    
  
  <div>
    <p>Hi Raffaele,</p>
    <p>Which database are you using? PostgreSQL?<br>
    </p>
    <p>The database provider does not allow modifications, if the user
      does not have permissions. <br>
    </p>
    <p>Can you confirm that the database changes even if the user does
      not have permission to write?</p>
    <p>Regards,</p>
    <p>Jorge Gustavo<br>
    </p>
    <div>On 27/04/21 08:40, Raffaele Ceretto
      wrote:<br>
    </div>
    <blockquote type="cite">
      
      <div dir="ltr">Good morning,
        <div><br>
        </div>
        <div>I created 2 users on my database.<br>
          one admin and one read-only.<br>
          The read-only one still allows me to edit and delete.<br>
          I get the message &quot;this user does not have the permissions,
          contact the administrator of the database&quot;, but does the
          modification anyway.<br>
          I have tried closing qgis and recreating the connections
          several times but nothing changes.<br>
          It appears to be bypassing the permissions<br>
          Could you help me?<br>
          <br>
          With best regards</div>
      </div>
      <br>
      <fieldset></fieldset>
      <pre>_______________________________________________
Qgis-user mailing list
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank" \
rel="noreferrer">Qgis-user@lists.osgeo.org</a> List info: <a \
href="https://lists.osgeo.org/mailman/listinfo/qgis-user" target="_blank" \
                rel="noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
                
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" \
target="_blank" rel="noreferrer">https://lists.osgeo.org/mailman/listinfo/qgis-user</a>
 </pre>
    </blockquote>
  </div>

_______________________________________________<br>
Qgis-user mailing list<br>
<a href="mailto:Qgis-user@lists.osgeo.org" target="_blank" \
rel="noreferrer">Qgis-user@lists.osgeo.org</a><br> List info: <a \
href="https://lists.osgeo.org/mailman/listinfo/qgis-user" rel="noreferrer noreferrer" \
                target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br>
                
Unsubscribe: <a href="https://lists.osgeo.org/mailman/listinfo/qgis-user" \
rel="noreferrer noreferrer" \
target="_blank">https://lists.osgeo.org/mailman/listinfo/qgis-user</a><br> \
</blockquote></div>



_______________________________________________
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


[prev in list] [next in list] [prev in thread] [next in thread]