[OSGeo Africa] SQL Database

Johan van Rensburg johan at geosol.com.na
Fri Jan 30 05:13:03 PST 2015

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.


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>

More information about the Africa mailing list