-
Notifications
You must be signed in to change notification settings - Fork 0
Expand file tree
/
Copy pathAddUserKaRi.sql
More file actions
157 lines (81 loc) · 6.12 KB
/
Copy pathAddUserKaRi.sql
File metadata and controls
157 lines (81 loc) · 6.12 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
-- Create User KaRi1 and set privileges
CREATE USER "KaRi1" WITH
LOGIN
NOSUPERUSER
INHERIT
NOCREATEDB
NOCREATEROLE
NOREPLICATION;
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_bereiche_int_bereicheid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_disgrp_x_disziplinen_int_disgrp_x_disziplinenid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_disziplinen_felder_int_disziplinen_felderid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_disziplinen_gruppen_int_disziplinen_gruppenid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_disziplinen_int_disziplinenid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_formeln_int_formelid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_gaue_int_gaueid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_gruppen_int_gruppenid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_gruppen_x_teilnehmer_int_gruppen_x_teilnehmerid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_jury_results_int_juryresultsid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_konten_int_kontenid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_laender_int_laenderid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_layout_felder_int_layout_felderid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_layouts_int_layoutid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_man_x_man_ab_int_man_x_man_abid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_man_x_teilnehmer_int_man_x_teilnehmerid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_mannschaften_abzug_int_mannschaften_abzugid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_mannschaften_int_mannschaftenid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_personen_int_personenid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_quali_leistungen_int_quali_leistungenid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_riegen_x_disziplinen_int_riegen_x_disziplinenid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_sport_int_sportid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_startreihenfolge_int_startreihenfolgeid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_status_int_statusid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_teilnehmer_int_teilnehmerid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_veranstaltungen_int_veranstaltungenid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_verbaende_int_verbaendeid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_vereine_int_vereineid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_wertungen_details_int_wertungen_detailsid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_wertungen_int_wertungenid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_wertungen_x_disziplinen_int_wertungen_x_disziplinenid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_wettkaempfe_dispos_int_wettkaempfe_disposid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_wettkaempfe_int_wettkaempfeid_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_wettkaempfe_x_disziplinen_int_wettkaempfe_x_disziplinen_seq TO "KaRi1";
GRANT SELECT, USAGE ON SEQUENCE turnfix.public.tfx_wettkampforte_int_wettkampforteid_seq TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_bereiche TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_disgrp_x_disziplinen TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_disziplinen TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_disziplinen_felder TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_disziplinen_gruppen TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_formeln TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_gaue TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_gruppen TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_gruppen_x_teilnehmer TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_jury_results TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_konten TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_laender TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_layout_felder TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_layouts TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_man_x_man_ab TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_man_x_teilnehmer TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_mannschaften TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_mannschaften_abzug TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_personen TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_quali_leistungen TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_riegen_x_disziplinen TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_sport TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_startreihenfolge TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_status TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_teilnehmer TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_veranstaltungen TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_verbaende TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_vereine TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_wertungen TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_wertungen_details TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_wertungen_x_disziplinen TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_wettkaempfe TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_wettkaempfe_dispos TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_wettkaempfe_x_disziplinen TO "KaRi1";
GRANT SELECT ON TABLE turnfix.public.tfx_wettkampforte TO "KaRi1";
GRANT ALL ON TABLE turnfix.public.tfx_wertungen_details TO "KaRi1";
GRANT ALL ON TABLE turnfix.public.tfx_wertungen_x_disziplinen TO "KaRi1";
GRANT ALL ON TABLE turnfix.public.tfx_status TO "KaRi1";