[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