[OSGeo Africa] SQL Database

[Johan van Rensburg]

Hi Gavin,

MS SQL Server 2012

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> [mailto:africa-bounces at lists.osgeo.org] On Behalf Of Gavin Fleming
Sent: Friday, January 30, 2015 3:08 PM
To: africa at lists.osgeo.org<mailto:africa at lists.osgeo.org>
Subject: Re: [OSGeo Africa] SQL Database

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:
Kartoza = Linfiniti ∪ Afrispatial
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/africa/attachments/20150130/1542083c/attachment.html>