[postgis-users] PostgreSQL/ Postgis schema definition for different group roles

[joachim.sommer.net at web.de]

Hallo List,

I am a newbie with PostgreSQL and Postgis. Have somebody made similar experiences or workflows ?

I am programming a geodatabase on windows plattform (WAPP) using later GeoServer as MapServer and Mapbender as Webmap-Client. For different access and programming phases I would like to use different schemas within my database - lets call it mygeodatabase -. Now I am getting a bit stuck with schema definition with PostgreSQL/Postgis cause I would like have different schema like different user groups ( i. e. group roles). For example one schema calling webuser and another webguardian. Each group role consists of a number of single users.

How to tell PostgreSQL to work with group roles instead of single role as schema access? 

Will this follow to further problems with postgis data types such as AddGeometryColum, cause it asks for schemaname ?

-- example: select AddGeometryColumn (<schema_name>, <table_name>, <column_name>, <srid>, <geometrytype>, <dimension>);

SELECT AddGeometryColumn ('anwender','bauwerk_poly','geom',31468,'MULTIPOLYGON',3);

Is there a better way for using groups in this context, as it seems to me that schema use refers just to a single user ? 

Thanks
Joe


_______________________________________________________________
SMS schreiben mit WEB.DE FreeMail - einfach, schnell und
kostenguenstig. Jetzt gleich testen! http://f.web.de/?mc=021192