source: trunk/import/grant.sql @ 358

Revision 353, 20.3 KB checked in by frank.jaeger, 6 years ago (diff)

kleine Verbesserungen am Post-Processing

Line 
1-- =====
2-- ALKIS
3-- =====
4
5-- Berechtigungen zu ALKIS fuer Mapserver (WMS)
6
7-- User
8--  "ms6"  = User 'Mapserver, Version 6.x',   aus Mapfile = Karten-Rendering
9--  "mb27" = User 'Mapbender, Version 2.7.x', aus Buchwerk-Navigation, PlugIn des Clients
10
11--  2012-02-17  PostNAS 0.7, pp_Tabellen, ms5 -> ms6
12--  2012-04-25  Tabelle pp_flurstueck_nr
13--  2013-01-15  mehr SchlÃŒsseltabellen rein
14--  2013-03-05  View "s_beschriftung" wird durch "ap_pto_stra" und "ap_pto_rest" ersetzt.
15--              View "s_nummer_nebengebaeude" wird durch "lfdnr_nebengebaeude" ersetzt.
16--  2013-03-25  View "grenzpunkt" und "gebaeude_txt"
17--  2013-04-19  Neues zum Thema "BodenschÀtzung", Views entfallen
18--  2013-10-24  Table "pp_strassenname" ersetzt View "ap_pto_stra" im WMS (ms6)
19--  2014-01-22  Neue Views fÃŒr CSV-Export, neue SchlÃŒsseltabelle "v_namnum_eigart"
20--  2014-09-08  PostNAS 0.8 ohne "alkis_beziehungen"
21--  2014-09-30  Umbenennung SchlÃŒsseltabellen (Prefix)
22--  2014-12-16  Views fÃŒr WMS Layer-Group Gebiete
23
24
25-- Tabellen
26-- ========
27
28-- PostGIS
29-- -------
30  GRANT SELECT ON TABLE geometry_columns TO ms6;
31  GRANT SELECT ON TABLE geometry_columns TO mb27;
32  GRANT SELECT ON TABLE spatial_ref_sys  TO ms6;
33  GRANT SELECT ON TABLE spatial_ref_sys  TO mb27;
34
35-- ALKIS / PostNAS
36-- ---------------
37-- Berechtigung fÃŒr Kartendarstellung
38--GRANT SELECT ON TABLE alkis_beziehungen TO ms6;
39  GRANT SELECT ON TABLE ap_darstellung TO ms6;
40  GRANT SELECT ON TABLE ap_lpo TO ms6;
41  GRANT SELECT ON TABLE ap_lto TO ms6;
42  GRANT SELECT ON TABLE ap_ppo TO ms6;
43  GRANT SELECT ON TABLE ap_pto TO ms6;
44  GRANT SELECT ON TABLE ax_anderefestlegungnachwasserrecht TO ms6;
45  GRANT SELECT ON TABLE ax_anschrift TO ms6;
46  GRANT SELECT ON TABLE ax_aufnahmepunkt TO ms6;
47  GRANT SELECT ON TABLE ax_bahnverkehr TO ms6;
48  GRANT SELECT ON TABLE ax_bahnverkehrsanlage TO ms6;
49  GRANT SELECT ON TABLE ax_baublock TO ms6;
50  GRANT SELECT ON TABLE ax_bauraumoderbodenordnungsrecht TO ms6;
51  GRANT SELECT ON TABLE ax_bauteil TO ms6;
52  GRANT SELECT ON TABLE ax_bauwerkimgewaesserbereich TO ms6;
53  GRANT SELECT ON TABLE ax_bauwerkimverkehrsbereich TO ms6;
54  GRANT SELECT ON TABLE ax_bauwerkoderanlagefuerindustrieundgewerbe TO ms6;
55  GRANT SELECT ON TABLE ax_bauwerkoderanlagefuersportfreizeitunderholung TO ms6;
56  GRANT SELECT ON TABLE ax_bergbaubetrieb TO ms6;
57  GRANT SELECT ON TABLE ax_besondereflurstuecksgrenze TO ms6;
58  GRANT SELECT ON TABLE ax_besonderegebaeudelinie TO ms6;
59  GRANT SELECT ON TABLE ax_besondererbauwerkspunkt TO ms6;
60  GRANT SELECT ON TABLE ax_besonderergebaeudepunkt TO ms6;
61  GRANT SELECT ON TABLE ax_besonderertopographischerpunkt TO ms6;
62  GRANT SELECT ON TABLE ax_bewertung TO ms6;
63  GRANT SELECT ON TABLE ax_bodenschaetzung TO ms6;
64  GRANT SELECT ON TABLE ax_boeschungkliff TO ms6;
65  GRANT SELECT ON TABLE ax_boeschungsflaeche TO ms6;
66  GRANT SELECT ON TABLE ax_buchungsblatt TO ms6;
67  GRANT SELECT ON TABLE ax_buchungsblattbezirk TO ms6;
68  GRANT SELECT ON TABLE ax_buchungsstelle TO ms6;
69  GRANT SELECT ON TABLE ax_bundesland TO ms6;
70  GRANT SELECT ON TABLE ax_dammwalldeich TO ms6;
71  GRANT SELECT ON TABLE ax_denkmalschutzrecht TO ms6;
72  GRANT SELECT ON TABLE ax_dienststelle TO ms6;
73  GRANT SELECT ON TABLE ax_felsenfelsblockfelsnadel TO ms6;
74  GRANT SELECT ON TABLE ax_firstlinie TO ms6;
75  GRANT SELECT ON TABLE ax_flaechebesondererfunktionalerpraegung TO ms6;
76  GRANT SELECT ON TABLE ax_flaechegemischternutzung TO ms6;
77  GRANT SELECT ON TABLE ax_fliessgewaesser TO ms6;
78  GRANT SELECT ON TABLE ax_flugverkehr TO ms6;
79  GRANT SELECT ON TABLE ax_flurstueck TO ms6;
80  GRANT SELECT ON TABLE ax_friedhof TO ms6;
81  GRANT SELECT ON TABLE ax_gebaeude TO ms6;
82  GRANT SELECT ON TABLE ax_gehoelz TO ms6;
83  GRANT SELECT ON TABLE ax_gemarkung TO ms6;
84  GRANT SELECT ON TABLE ax_gemarkungsteilflur TO ms6;
85  GRANT SELECT ON TABLE ax_gemeinde TO ms6;
86  GRANT SELECT ON TABLE ax_georeferenziertegebaeudeadresse TO ms6;
87  GRANT SELECT ON TABLE ax_gewaessermerkmal TO ms6;
88  GRANT SELECT ON TABLE ax_gleis TO ms6;
89  GRANT SELECT ON TABLE ax_grablochderbodenschaetzung TO ms6;
90  GRANT SELECT ON TABLE ax_grenzpunkt TO ms6;
91  GRANT SELECT ON TABLE ax_hafenbecken TO ms6;
92  GRANT SELECT ON TABLE ax_halde TO ms6;
93  GRANT SELECT ON TABLE ax_heide TO ms6;
94  GRANT SELECT ON TABLE ax_historischesbauwerkoderhistorischeeinrichtung TO ms6;
95  GRANT SELECT ON TABLE ax_historischesflurstueck TO ms6;
96  GRANT SELECT ON TABLE ax_historischesflurstueckalb TO ms6;
97  GRANT SELECT ON TABLE ax_historischesflurstueckohneraumbezug TO ms6;
98  GRANT SELECT ON TABLE ax_hoehleneingang TO ms6;
99  GRANT SELECT ON TABLE ax_industrieundgewerbeflaeche TO ms6;
100  GRANT SELECT ON TABLE ax_klassifizierungnachstrassenrecht TO ms6;
101  GRANT SELECT ON TABLE ax_klassifizierungnachwasserrecht TO ms6;
102  GRANT SELECT ON TABLE ax_kleinraeumigerlandschaftsteil TO ms6;
103  GRANT SELECT ON TABLE ax_kommunalesgebiet TO ms6;
104  GRANT SELECT ON TABLE ax_kreisregion TO ms6;
105  GRANT SELECT ON TABLE ax_lagebezeichnungkatalogeintrag TO ms6;
106  GRANT SELECT ON TABLE ax_lagebezeichnungmithausnummer TO ms6;
107  GRANT SELECT ON TABLE ax_lagebezeichnungmitpseudonummer TO ms6;
108  GRANT SELECT ON TABLE ax_lagebezeichnungohnehausnummer TO ms6;
109  GRANT SELECT ON TABLE ax_landwirtschaft TO ms6;
110  GRANT SELECT ON TABLE ax_leitung TO ms6;
111  GRANT SELECT ON TABLE ax_moor TO ms6;
112  GRANT SELECT ON TABLE ax_musterlandesmusterundvergleichsstueck TO ms6;
113  GRANT SELECT ON TABLE ax_namensnummer TO ms6;
114  GRANT SELECT ON TABLE ax_naturumweltoderbodenschutzrecht TO ms6;
115  GRANT SELECT ON TABLE ax_person TO ms6;
116  GRANT SELECT ON TABLE ax_platz TO ms6;
117  GRANT SELECT ON TABLE ax_punktortag TO ms6;
118  GRANT SELECT ON TABLE ax_punktortau TO ms6;
119  GRANT SELECT ON TABLE ax_punktortta TO ms6;
120  GRANT SELECT ON TABLE ax_regierungsbezirk TO ms6;
121  GRANT SELECT ON TABLE ax_schiffsverkehr TO ms6;
122  GRANT SELECT ON TABLE ax_schutzgebietnachwasserrecht TO ms6;
123  GRANT SELECT ON TABLE ax_schutzzone TO ms6;
124  GRANT SELECT ON TABLE ax_sonstigervermessungspunkt TO ms6;
125  GRANT SELECT ON TABLE ax_sonstigesbauwerkodersonstigeeinrichtung TO ms6;
126  GRANT SELECT ON TABLE ax_sonstigesrecht TO ms6;
127  GRANT SELECT ON TABLE ax_sportfreizeitunderholungsflaeche TO ms6;
128  GRANT SELECT ON TABLE ax_stehendesgewaesser TO ms6;
129  GRANT SELECT ON TABLE ax_strassenverkehr TO ms6;
130  GRANT SELECT ON TABLE ax_strassenverkehrsanlage TO ms6;
131  GRANT SELECT ON TABLE ax_sumpf TO ms6;
132  GRANT SELECT ON TABLE ax_tagebaugrubesteinbruch TO ms6;
133  GRANT SELECT ON TABLE ax_transportanlage TO ms6;
134  GRANT SELECT ON TABLE ax_turm TO ms6;
135  GRANT SELECT ON TABLE ax_unlandvegetationsloseflaeche TO ms6;
136  GRANT SELECT ON TABLE ax_untergeordnetesgewaesser TO ms6;
137  GRANT SELECT ON TABLE ax_vegetationsmerkmal TO ms6;
138  GRANT SELECT ON TABLE ax_vorratsbehaelterspeicherbauwerk TO ms6;
139  GRANT SELECT ON TABLE ax_wald TO ms6;
140  GRANT SELECT ON TABLE ax_weg TO ms6;
141  GRANT SELECT ON TABLE ax_wegpfadsteig TO ms6;
142  GRANT SELECT ON TABLE ax_wohnbauflaeche TO ms6;
143  GRANT SELECT ON TABLE ax_wohnplatz TO ms6;
144
145-- Berechtigung fuer Buchauskunft
146--GRANT SELECT ON TABLE alkis_beziehungen TO mb27;
147  GRANT SELECT ON TABLE ap_darstellung TO mb27;
148  GRANT SELECT ON TABLE ap_lpo TO mb27;
149  GRANT SELECT ON TABLE ap_lto TO mb27;
150  GRANT SELECT ON TABLE ap_ppo TO mb27;
151  GRANT SELECT ON TABLE ap_pto TO mb27;
152  GRANT SELECT ON TABLE ax_anderefestlegungnachwasserrecht TO mb27;
153  GRANT SELECT ON TABLE ax_anschrift TO mb27;
154  GRANT SELECT ON TABLE ax_aufnahmepunkt TO mb27;
155  GRANT SELECT ON TABLE ax_bahnverkehr TO mb27;
156  GRANT SELECT ON TABLE ax_bahnverkehrsanlage TO mb27;
157  GRANT SELECT ON TABLE ax_baublock TO mb27;
158  GRANT SELECT ON TABLE ax_bauraumoderbodenordnungsrecht TO mb27;
159  GRANT SELECT ON TABLE ax_bauteil TO mb27;
160  GRANT SELECT ON TABLE ax_bauwerkimgewaesserbereich TO mb27;
161  GRANT SELECT ON TABLE ax_bauwerkimverkehrsbereich TO mb27;
162  GRANT SELECT ON TABLE ax_bauwerkoderanlagefuerindustrieundgewerbe TO mb27;
163  GRANT SELECT ON TABLE ax_bauwerkoderanlagefuersportfreizeitunderholung TO mb27;
164  GRANT SELECT ON TABLE ax_bergbaubetrieb TO mb27;
165  GRANT SELECT ON TABLE ax_besondereflurstuecksgrenze TO mb27;
166  GRANT SELECT ON TABLE ax_besonderegebaeudelinie TO mb27;
167  GRANT SELECT ON TABLE ax_besondererbauwerkspunkt TO mb27;
168  GRANT SELECT ON TABLE ax_besonderergebaeudepunkt TO mb27;
169  GRANT SELECT ON TABLE ax_besonderertopographischerpunkt TO mb27;
170  GRANT SELECT ON TABLE ax_bewertung TO mb27;
171  GRANT SELECT ON TABLE ax_bodenschaetzung TO mb27;
172  GRANT SELECT ON TABLE ax_boeschungkliff TO mb27;
173  GRANT SELECT ON TABLE ax_boeschungsflaeche TO mb27;
174  GRANT SELECT ON TABLE ax_buchungsblatt TO mb27;
175  GRANT SELECT ON TABLE ax_buchungsblattbezirk TO mb27;
176  GRANT SELECT ON TABLE ax_buchungsstelle TO mb27;
177  GRANT SELECT ON TABLE ax_bundesland TO mb27;
178  GRANT SELECT ON TABLE ax_dammwalldeich TO mb27;
179  GRANT SELECT ON TABLE ax_denkmalschutzrecht TO mb27;
180  GRANT SELECT ON TABLE ax_dienststelle TO mb27;
181  GRANT SELECT ON TABLE ax_felsenfelsblockfelsnadel TO mb27;
182  GRANT SELECT ON TABLE ax_firstlinie TO mb27;
183  GRANT SELECT ON TABLE ax_flaechebesondererfunktionalerpraegung TO mb27;
184  GRANT SELECT ON TABLE ax_flaechegemischternutzung TO mb27;
185  GRANT SELECT ON TABLE ax_fliessgewaesser TO mb27;
186  GRANT SELECT ON TABLE ax_flugverkehr TO mb27;
187  GRANT SELECT ON TABLE ax_flurstueck TO mb27;
188  GRANT SELECT ON TABLE ax_friedhof TO mb27;
189  GRANT SELECT ON TABLE ax_gebaeude TO mb27;
190  GRANT SELECT ON TABLE ax_gehoelz TO mb27;
191  GRANT SELECT ON TABLE ax_gemarkung TO mb27;
192  GRANT SELECT ON TABLE ax_gemarkungsteilflur TO mb27;
193  GRANT SELECT ON TABLE ax_gemeinde TO mb27;
194  GRANT SELECT ON TABLE ax_georeferenziertegebaeudeadresse TO mb27;
195  GRANT SELECT ON TABLE ax_gewaessermerkmal TO mb27;
196  GRANT SELECT ON TABLE ax_gleis TO mb27;
197  GRANT SELECT ON TABLE ax_grablochderbodenschaetzung TO mb27;
198  GRANT SELECT ON TABLE ax_grenzpunkt TO mb27;
199  GRANT SELECT ON TABLE ax_hafenbecken TO mb27;
200  GRANT SELECT ON TABLE ax_halde TO mb27;
201  GRANT SELECT ON TABLE ax_heide TO mb27;
202  GRANT SELECT ON TABLE ax_historischesbauwerkoderhistorischeeinrichtung TO mb27;
203  GRANT SELECT ON TABLE ax_historischesflurstueck TO mb27;
204  GRANT SELECT ON TABLE ax_historischesflurstueckalb TO mb27;
205  GRANT SELECT ON TABLE ax_historischesflurstueckohneraumbezug TO mb27;
206  GRANT SELECT ON TABLE ax_hoehleneingang TO mb27;
207  GRANT SELECT ON TABLE ax_industrieundgewerbeflaeche TO mb27;
208  GRANT SELECT ON TABLE ax_klassifizierungnachstrassenrecht TO mb27;
209  GRANT SELECT ON TABLE ax_klassifizierungnachwasserrecht TO mb27;
210  GRANT SELECT ON TABLE ax_kleinraeumigerlandschaftsteil TO mb27;
211  GRANT SELECT ON TABLE ax_kommunalesgebiet TO mb27;
212  GRANT SELECT ON TABLE ax_kreisregion TO mb27;
213  GRANT SELECT ON TABLE ax_lagebezeichnungkatalogeintrag TO mb27;
214  GRANT SELECT ON TABLE ax_lagebezeichnungmithausnummer TO mb27;
215  GRANT SELECT ON TABLE ax_lagebezeichnungmitpseudonummer TO mb27;
216  GRANT SELECT ON TABLE ax_lagebezeichnungohnehausnummer TO mb27;
217  GRANT SELECT ON TABLE ax_landwirtschaft TO mb27;
218  GRANT SELECT ON TABLE ax_leitung TO mb27;
219  GRANT SELECT ON TABLE ax_moor TO mb27;
220  GRANT SELECT ON TABLE ax_musterlandesmusterundvergleichsstueck TO mb27;
221  GRANT SELECT ON TABLE ax_namensnummer TO mb27;
222  GRANT SELECT ON TABLE ax_naturumweltoderbodenschutzrecht TO mb27;
223  GRANT SELECT ON TABLE ax_person TO mb27;
224  GRANT SELECT ON TABLE ax_platz TO mb27;
225  GRANT SELECT ON TABLE ax_punktortag TO mb27;
226  GRANT SELECT ON TABLE ax_punktortau TO mb27;
227  GRANT SELECT ON TABLE ax_punktortta TO mb27;
228  GRANT SELECT ON TABLE ax_regierungsbezirk TO mb27;
229  GRANT SELECT ON TABLE ax_schiffsverkehr TO mb27;
230  GRANT SELECT ON TABLE ax_schutzgebietnachwasserrecht TO mb27;
231  GRANT SELECT ON TABLE ax_schutzzone TO mb27;
232  GRANT SELECT ON TABLE ax_sonstigervermessungspunkt TO mb27;
233  GRANT SELECT ON TABLE ax_sonstigesbauwerkodersonstigeeinrichtung TO mb27;
234  GRANT SELECT ON TABLE ax_sonstigesrecht TO mb27;
235  GRANT SELECT ON TABLE ax_sportfreizeitunderholungsflaeche TO mb27;
236  GRANT SELECT ON TABLE ax_stehendesgewaesser TO mb27;
237  GRANT SELECT ON TABLE ax_strassenverkehr TO mb27;
238  GRANT SELECT ON TABLE ax_strassenverkehrsanlage TO mb27;
239  GRANT SELECT ON TABLE ax_sumpf TO mb27;
240  GRANT SELECT ON TABLE ax_tagebaugrubesteinbruch TO mb27;
241  GRANT SELECT ON TABLE ax_transportanlage TO mb27;
242  GRANT SELECT ON TABLE ax_turm TO mb27;
243  GRANT SELECT ON TABLE ax_unlandvegetationsloseflaeche TO mb27;
244  GRANT SELECT ON TABLE ax_untergeordnetesgewaesser TO mb27;
245  GRANT SELECT ON TABLE ax_vegetationsmerkmal TO mb27;
246  GRANT SELECT ON TABLE ax_vorratsbehaelterspeicherbauwerk TO mb27;
247  GRANT SELECT ON TABLE ax_wald TO mb27;
248  GRANT SELECT ON TABLE ax_weg TO mb27;
249  GRANT SELECT ON TABLE ax_wegpfadsteig TO mb27;
250  GRANT SELECT ON TABLE ax_wohnbauflaeche TO mb27;
251  GRANT SELECT ON TABLE ax_wohnplatz TO mb27;
252
253-- Berechtigungen fuer optimierte Nutzungsarten
254-- --------------------------------------------
255  GRANT SELECT ON TABLE nutzung_meta                       TO ms6;
256  GRANT SELECT ON TABLE nutzung_meta                       TO mb27;
257  GRANT SELECT ON TABLE nutzung                            TO ms6;
258  GRANT SELECT ON TABLE nutzung                            TO mb27;
259  GRANT SELECT ON TABLE nutzung_class                      TO ms6;
260  GRANT SELECT ON TABLE nutzung_class                      TO mb27;
261
262-- Post-Processung
263-- --------------------------------------------
264--GRANT SELECT ON TABLE  gemarkung_in_gemeinde             TO ms6;
265--GRANT SELECT ON TABLE  gemarkung_in_gemeinde             TO mb27;
266  GRANT SELECT ON TABLE  gemeinde_gemarkung                TO ms6;
267  GRANT SELECT ON TABLE  gemeinde_gemarkung                TO mb27;
268  GRANT SELECT ON TABLE  pp_gemeinde                       TO ms6;
269  GRANT SELECT ON TABLE  pp_gemeinde                       TO mb27;
270  GRANT SELECT ON TABLE  pp_gemarkung                      TO ms6;
271  GRANT SELECT ON TABLE  pp_gemarkung                      TO mb27;
272  GRANT SELECT ON TABLE  pp_flur                           TO ms6;
273  GRANT SELECT ON TABLE  pp_flur                           TO mb27;
274  GRANT SELECT ON TABLE  pp_flurstueck_nr                  TO ms6;
275
276  GRANT SELECT ON TABLE  pp_strassenname_p                 TO ms6;
277  GRANT SELECT ON TABLE  pp_strassenname_l                 TO ms6;
278
279  GRANT SELECT ON TABLE  gemeinde_person                   TO ms6;
280  GRANT SELECT ON TABLE  gemeinde_person                   TO mb27;
281
282
283-- Schluesseltabellen
284-- ------------------
285
286-- GebÀude
287GRANT SELECT ON TABLE v_geb_bauweise                       TO ms6;
288GRANT SELECT ON TABLE v_geb_bauweise                       TO mb27;
289GRANT SELECT ON TABLE v_geb_funktion                       TO ms6;
290GRANT SELECT ON TABLE v_geb_funktion                       TO mb27;
291GRANT SELECT ON TABLE v_geb_dachform                       TO ms6;
292GRANT SELECT ON TABLE v_geb_dachform                       TO mb27;
293GRANT SELECT ON TABLE v_geb_weiterefkt                     TO ms6;
294GRANT SELECT ON TABLE v_geb_weiterefkt                     TO mb27;
295GRANT SELECT ON TABLE v_geb_zustand                        TO ms6;
296GRANT SELECT ON TABLE v_geb_zustand                        TO mb27;
297GRANT SELECT ON TABLE v_bauteil_bauart                     TO ms6;
298GRANT SELECT ON TABLE v_bauteil_bauart                     TO mb27;
299
300-- BodenschÀtzung
301GRANT SELECT ON TABLE v_bschaetz_bodenart                  TO ms6;
302GRANT SELECT ON TABLE v_bschaetz_bodenart                  TO mb27;
303GRANT SELECT ON TABLE v_bschaetz_entsteh_klima             TO ms6;
304GRANT SELECT ON TABLE v_bschaetz_entsteh_klima             TO mb27;
305GRANT SELECT ON TABLE v_bschaetz_kulturart                 TO ms6;
306GRANT SELECT ON TABLE v_bschaetz_kulturart                 TO mb27;
307GRANT SELECT ON TABLE v_bschaetz_zustandsstufe             TO ms6;
308GRANT SELECT ON TABLE v_bschaetz_zustandsstufe             TO mb27;
309GRANT SELECT ON TABLE v_bschaetz_sonst                     TO ms6;
310GRANT SELECT ON TABLE v_bschaetz_sonst                     TO mb27;
311GRANT SELECT ON TABLE v_grabloch_bedeutg                   TO ms6;
312GRANT SELECT ON TABLE v_grabloch_bedeutg                   TO mb27;
313GRANT SELECT ON TABLE v_muster_merkmal                     TO ms6;
314GRANT SELECT ON TABLE v_muster_merkmal                     TO mb27;
315GRANT SELECT ON TABLE v_bewertg_klass                      TO ms6;
316GRANT SELECT ON TABLE v_bewertg_klass                      TO mb27;
317
318-- BodenschÀtzung Views
319GRANT SELECT ON TABLE s_bodensch_wms                       TO ms6;
320GRANT SELECT ON TABLE s_bodensch_ent                       TO ms6;
321GRANT SELECT ON TABLE s_bodensch_po                        TO ms6;
322GRANT SELECT ON TABLE s_bodensch_tx                        TO ms6;
323GRANT SELECT ON TABLE s_zuordungspfeilspitze_bodensch      TO ms6;
324GRANT SELECT ON TABLE s_zuordungspfeil_bodensch            TO ms6;
325
326-- Recht
327GRANT SELECT ON TABLE v_denkmal_adf                        TO ms6;
328GRANT SELECT ON TABLE v_denkmal_adf                        TO mb27;
329GRANT SELECT ON TABLE v_forstrecht_adf                     TO ms6;
330GRANT SELECT ON TABLE v_forstrecht_adf                     TO mb27;
331GRANT SELECT ON TABLE v_forstrecht_besfkt                  TO ms6;
332GRANT SELECT ON TABLE v_forstrecht_besfkt                  TO mb27;
333GRANT SELECT ON TABLE v_baurecht_adf                       TO ms6;
334GRANT SELECT ON TABLE v_baurecht_adf                       TO mb27;
335GRANT SELECT ON TABLE v_andstrass_adf                      TO ms6;
336GRANT SELECT ON TABLE v_andstrass_adf                      TO mb27;
337GRANT SELECT ON TABLE v_klass_strass_adf                   TO ms6;
338GRANT SELECT ON TABLE v_klass_strass_adf                   TO mb27;
339GRANT SELECT ON TABLE v_klass_wasser_adf                   TO ms6;
340GRANT SELECT ON TABLE v_klass_wasser_adf                   TO mb27;
341GRANT SELECT ON TABLE v_umweltrecht_adf                    TO ms6;
342GRANT SELECT ON TABLE v_umweltrecht_adf                    TO mb27;
343GRANT SELECT ON TABLE v_sonstrecht_adf                     TO ms6;
344GRANT SELECT ON TABLE v_sonstrecht_adf                     TO mb27;
345
346-- Sonstige SchlÃŒsseltabellen
347GRANT SELECT ON TABLE v_bs_buchungsart                     TO ms6;
348GRANT SELECT ON TABLE v_bs_buchungsart                     TO mb27;
349GRANT SELECT ON TABLE v_namnum_eigart                      TO ms6;
350GRANT SELECT ON TABLE v_namnum_eigart                      TO mb27;
351GRANT SELECT ON TABLE v_datenerhebung                      TO ms6;
352GRANT SELECT ON TABLE v_datenerhebung                      TO mb27;
353
354
355-- VIEWS
356-- =====
357  GRANT SELECT ON TABLE s_hausnummer_gebaeude              TO ms6;
358--GRANT SELECT ON TABLE s_nummer_nebengebaeude             TO ms6;
359  GRANT SELECT ON TABLE lfdnr_nebengebaeude                TO ms6;
360  GRANT SELECT ON TABLE s_zugehoerigkeitshaken_flurstueck  TO ms6;
361  GRANT SELECT ON TABLE s_zuordungspfeil_flurstueck        TO ms6;
362  GRANT SELECT ON TABLE s_zuordungspfeilspitze_flurstueck  TO ms6;
363  GRANT SELECT ON TABLE s_zuordungspfeil_bodensch          TO ms6;
364  GRANT SELECT ON TABLE s_zuordungspfeilspitze_bodensch    TO ms6;
365  GRANT SELECT ON TABLE s_zuordungspfeil_gebaeude          TO ms6;
366--GRANT SELECT ON TABLE s_flurstueck_nr                    TO ms6;
367--GRANT SELECT ON TABLE s_beschriftung                     TO ms6;
368--GRANT SELECT ON TABLE ap_pto_stra                        TO ms6;
369  GRANT SELECT ON TABLE ap_pto_rest                        TO ms6;
370  GRANT SELECT ON TABLE grenzpunkt                         TO ms6;
371  GRANT SELECT ON TABLE gebaeude_txt                       TO ms6;
372-- VIEWS wie OBK
373  GRANT SELECT ON TABLE sk2012_flurgrenze                  TO ms6;
374  GRANT SELECT ON TABLE sk2014_gemarkungsgrenze            TO ms6;
375  GRANT SELECT ON TABLE sk2018_bundeslandgrenze            TO ms6;
376  GRANT SELECT ON TABLE sk2020_regierungsbezirksgrenze     TO ms6;
377  GRANT SELECT ON TABLE sk2022_gemeindegrenze              TO ms6;
378  GRANT SELECT ON TABLE sk201x_politische_grenze           TO ms6;
379
380  GRANT SELECT ON TABLE doppelverbindung                   TO mb27;
381  GRANT SELECT ON TABLE exp_csv                            TO mb27;
382  GRANT SELECT ON TABLE exp_csv_str                        TO mb27;
383
384-- WMS Layer-Group Gebiete, individuell nach GemeindeschlÃŒssel gefiltert
385  GRANT SELECT ON TABLE gebiet_flur                        TO ms6;
386  GRANT SELECT ON TABLE gebiet_gemarkung                   TO ms6;
387  GRANT SELECT ON TABLE gebiet_gemeinde                    TO ms6;
388
389-- END --
Note: See TracBrowser for help on using the repository browser.