[postgis-users] How to remotely edit a postgis db?

Maria Arias de Reyna marias at emergya.es
Wed Jan 26 00:59:04 PST 2011


El Wednesday 26 January 2011, Robert Buckley escribió:
> Hi,
> 
> with Quantum GIS v1.6.0 I just managed to connect and edit!!!
> I don´t believe i because I was trying all last night and it wasn´t
> working? ok...so it works! great!
> 
> As a newbie then, I have a questions?
> 
> How do I define different users to different tables in a database?...I was
> thinking of creating various databases for different users. Could I then
> define different user accounts/roles to the databases to ensure that only
> correct person is able to edit his/her database?...for example I have a
> region with 10 counties. If I create 10 databases for each county, I could
> then assign 10 users (county_1, county_2 ...county_10) to database_1,
> Database_2...Database_10 etc so that the user "County_2" can only edit the
> database "County_2".
> 
> does that make sense? Is it feasable/doable?

If you can think of it, you can do it ;)

PostGIS is only an extension of PostgreSQL. You might want to check how roles 
and users work on PostgreSQL: 
http://www.postgresql.org/docs/8.4/static/user-manag.html

Anyway, try not to create a new thread every time you have a new question of 
the same topic. It makes it difficult to follow.

> 
> yours,
> 
> Robert


-- 
María Arias de Reyna Domínguez
Área de Operaciones

Emergya Consultoría 
Tfno: +34 954 51 75 77 / +34 607 43 74 27
Fax: +34 954 51 64 73 
www.emergya.es 



More information about the postgis-users mailing list