[OSGeo Africa] SQL Database

Gavin Fleming gavin at kartoza.com
Fri Jan 30 05:07:44 PST 2015


Hi Johan

What database are you using? You'd set up permissions in the database,
in PostgreSQL like this:

GRANT SELECT ON yourtable TO user;
GRANT ALL ON yourtable TO editor;

And ensure that the database connection each user connects with contains
the role name that matches their permissions.

Gavin

On 30/01/2015 14:58, Johan van Rensburg wrote:
>
> Hi
>
>  
>
> I have two types of users the ones that can edit the data and ones
> that cannot edit the SQL database
>
>  
>
> Best Regards
>
> * *
>
> *Johan van Rensburg*
>
> *Professional GISc Practitioner PGP 0168*
>
> ------------------------------------------------------------------------
>
> Geo Business Solutions    l <http://www.munsys.com/>www.geosol.com.na
> <http://www.geosol.com.na/> l Tel: (061) 226929    l Fax: (061) 229623
>
> ------------------------------------------------------------------------
>
> DISCLAIMER: This e-mail must not be copied, disclosed or used by any
> person other than the addressee(s) named above. Geo Business
> Solutions does not endorse or accept responsibility for any personal
> views expressed in this e-mail.
>
> ------------------------------------------------------------------------
>
> */P/***Please consider the environment before printing this e-mail
>
>  
>
>  
>
>  
>
>  
>
> *From:*africa-bounces at lists.osgeo.org
> [mailto:africa-bounces at lists.osgeo.org] *On Behalf Of *Sarel
> *Sent:* Friday, January 30, 2015 2:56 PM
> *To:* Africa local chapter discussions
> *Subject:* Re: [OSGeo Africa] SQL Database
>
>  
>
> Hi
>
> I general only give user read rights, thus should be done from the DB
> side.
>
> Regards
> Sarel
>
> ------------------------------------------------------------------------
>
> *From: *Johan van Rensburg <mailto:johan at geosol.com.na>
> *Sent: *‎2015-‎01-‎30 02:33 PM
> *To: *Africa local chapter discussions <mailto:africa at lists.osgeo.org>
> *Subject: *[OSGeo Africa] SQL Database
>
> Dear All,
>
>  
>
> Can someone please advise how to set the opening of an SQL data layer
> as read only? In QGIS 2.2.0
>
>  
>
> Best Regards
>
> * *
>
> *Johan van Rensburg*
>
> *Professional GISc Practitioner PGP 0168*
>
> ------------------------------------------------------------------------
>
> Geo Business Solutions    l <http://www.munsys.com/>www.geosol.com.na
> <http://www.geosol.com.na/> l Tel: (061) 226929    l Fax: (061) 229623
>
> ------------------------------------------------------------------------
>
> DISCLAIMER: This e-mail must not be copied, disclosed or used by any
> person other than the addressee(s) named above. Geo Business
> Solutions does not endorse or accept responsibility for any personal
> views expressed in this e-mail.
>
> ------------------------------------------------------------------------
>
> */P/***Please consider the environment before printing this e-mail
>
>  
>
>  
>
>  
>
>  
>
> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>
>
>
> _______________________________________________
> Africa mailing list
> Africa at lists.osgeo.org
> You can UNSUBSCRIBE at http://lists.osgeo.org/mailman/listinfo/africa


-- 
------------------------------------------------------------------------------------------
Gavin Fleming PGP 1234
Visit http://kartoza.com <http://kartoza.com/>to find out about open source:
* Desktop GIS programming services
* Geospatial web development
* GIS Training
* Consulting Services
Skype: phlemingo
-------------------------------------------------------------------------------------------
Kartoza = Linfiniti ∪ Afrispatial
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/africa/attachments/20150130/f5e5889c/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: KartozaWebBanner.png
Type: image/png
Size: 22131 bytes
Desc: not available
URL: <http://lists.osgeo.org/pipermail/africa/attachments/20150130/f5e5889c/attachment-0001.png>


More information about the Africa mailing list