-
Notifications
You must be signed in to change notification settings - Fork 11
/
Copy pathhlt_grant_privileges_hltdev_ORACLE.sql
366 lines (339 loc) · 18.5 KB
/
hlt_grant_privileges_hltdev_ORACLE.sql
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
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
--
-- grant privileges to cms_hltdev tablespace to users
-- cms_hltdev_admin / cms_hltdev_writer / cms_hltdev_reader
--
--
-- cms_hltdev_admin
--
-- SELECT
GRANT SELECT ON SuperIdReleaseAssoc TO cms_hltdev_admin;
GRANT SELECT ON SoftwareReleases TO cms_hltdev_admin;
GRANT SELECT ON SoftwareSubsystems TO cms_hltdev_admin;
GRANT SELECT ON SoftwarePackages TO cms_hltdev_admin;
GRANT SELECT ON ServiceTemplates TO cms_hltdev_admin;
GRANT SELECT ON EDSourceTemplates TO cms_hltdev_admin;
GRANT SELECT ON ESSourceTemplates TO cms_hltdev_admin;
GRANT SELECT ON ESModuleTemplates TO cms_hltdev_admin;
GRANT SELECT ON ModuleTemplates TO cms_hltdev_admin;
GRANT SELECT ON ModuleTypes TO cms_hltdev_admin;
GRANT SELECT ON Configurations TO cms_hltdev_admin;
GRANT SELECT ON Directories TO cms_hltdev_admin;
GRANT SELECT ON Int32ParamValues TO cms_hltdev_admin;
GRANT SELECT ON VInt32ParamValues TO cms_hltdev_admin;
GRANT SELECT ON UInt32ParamValues TO cms_hltdev_admin;
GRANT SELECT ON VUInt32ParamValues TO cms_hltdev_admin;
GRANT SELECT ON Int64ParamValues TO cms_hltdev_admin;
GRANT SELECT ON VInt64ParamValues TO cms_hltdev_admin;
GRANT SELECT ON UInt64ParamValues TO cms_hltdev_admin;
GRANT SELECT ON VUInt64ParamValues TO cms_hltdev_admin;
GRANT SELECT ON BoolParamValues TO cms_hltdev_admin;
GRANT SELECT ON DoubleParamValues TO cms_hltdev_admin;
GRANT SELECT ON VDoubleParamValues TO cms_hltdev_admin;
GRANT SELECT ON StringParamValues TO cms_hltdev_admin;
GRANT SELECT ON VStringParamValues TO cms_hltdev_admin;
GRANT SELECT ON InputTagParamValues TO cms_hltdev_admin;
GRANT SELECT ON VInputTagParamValues TO cms_hltdev_admin;
GRANT SELECT ON EventIDParamValues TO cms_hltdev_admin;
GRANT SELECT ON VEventIDParamValues TO cms_hltdev_admin;
GRANT SELECT ON FileInPathParamValues TO cms_hltdev_admin;
GRANT SELECT ON SuperIdParameterAssoc TO cms_hltdev_admin;
GRANT SELECT ON SuperIdParamSetAssoc TO cms_hltdev_admin;
GRANT SELECT ON SuperIdVecParamSetAssoc TO cms_hltdev_admin;
GRANT SELECT ON ParameterSets TO cms_hltdev_admin;
GRANT SELECT ON VecParameterSets TO cms_hltdev_admin;
GRANT SELECT ON Parameters TO cms_hltdev_admin;
GRANT SELECT ON SuperIds TO cms_hltdev_admin;
GRANT SELECT ON ParameterTypes TO cms_hltdev_admin;
GRANT SELECT ON ReleaseId_Sequence TO cms_hltdev_admin;
GRANT SELECT ON SubsysId_Sequence TO cms_hltdev_admin;
GRANT SELECT ON PackageId_Sequence TO cms_hltdev_admin;
GRANT SELECT ON DirId_Sequence TO cms_hltdev_admin;
GRANT SELECT ON ConfigId_Sequence TO cms_hltdev_admin;
GRANT SELECT ON StreamId_Sequence TO cms_hltdev_admin;
GRANT SELECT ON DatasetId_Sequence TO cms_hltdev_admin;
GRANT SELECT ON SuperId_Sequence TO cms_hltdev_admin;
GRANT SELECT ON PathId_Sequence TO cms_hltdev_admin;
GRANT SELECT ON SequenceId_Sequence TO cms_hltdev_admin;
GRANT SELECT ON ParamId_Sequence TO cms_hltdev_admin;
-- INSERT
GRANT INSERT ON SuperIdReleaseAssoc TO cms_hltdev_admin;
GRANT INSERT ON SoftwareReleases TO cms_hltdev_admin;
GRANT INSERT ON SoftwareSubsystems TO cms_hltdev_admin;
GRANT INSERT ON SoftwarePackages TO cms_hltdev_admin;
GRANT INSERT ON ServiceTemplates TO cms_hltdev_admin;
GRANT INSERT ON EDSourceTemplates TO cms_hltdev_admin;
GRANT INSERT ON ESSourceTemplates TO cms_hltdev_admin;
GRANT INSERT ON ESModuleTemplates TO cms_hltdev_admin;
GRANT INSERT ON ModuleTemplates TO cms_hltdev_admin;
GRANT INSERT ON Int32ParamValues TO cms_hltdev_admin;
GRANT INSERT ON VInt32ParamValues TO cms_hltdev_admin;
GRANT INSERT ON UInt32ParamValues TO cms_hltdev_admin;
GRANT INSERT ON VUInt32ParamValues TO cms_hltdev_admin;
GRANT INSERT ON Int64ParamValues TO cms_hltdev_admin;
GRANT INSERT ON VInt64ParamValues TO cms_hltdev_admin;
GRANT INSERT ON UInt64ParamValues TO cms_hltdev_admin;
GRANT INSERT ON VUInt64ParamValues TO cms_hltdev_admin;
GRANT INSERT ON BoolParamValues TO cms_hltdev_admin;
GRANT INSERT ON DoubleParamValues TO cms_hltdev_admin;
GRANT INSERT ON VDoubleParamValues TO cms_hltdev_admin;
GRANT INSERT ON StringParamValues TO cms_hltdev_admin;
GRANT INSERT ON VStringParamValues TO cms_hltdev_admin;
GRANT INSERT ON InputTagParamValues TO cms_hltdev_admin;
GRANT INSERT ON VInputTagParamValues TO cms_hltdev_admin;
GRANT INSERT ON EventIDParamValues TO cms_hltdev_admin;
GRANT INSERT ON VEventIDParamValues TO cms_hltdev_admin;
GRANT INSERT ON FileInPathParamValues TO cms_hltdev_admin;
GRANT INSERT ON SuperIdParameterAssoc TO cms_hltdev_admin;
GRANT INSERT ON SuperIdParamSetAssoc TO cms_hltdev_admin;
GRANT INSERT ON SuperIdVecParamSetAssoc TO cms_hltdev_admin;
GRANT INSERT ON ParameterSets TO cms_hltdev_admin;
GRANT INSERT ON VecParameterSets TO cms_hltdev_admin;
GRANT INSERT ON Parameters TO cms_hltdev_admin;
GRANT INSERT ON SuperIds TO cms_hltdev_admin;
--
-- cms_hltdev_writer
--
-- SELECT
GRANT SELECT ON SuperIdReleaseAssoc TO cms_hltdev_writer;
GRANT SELECT ON SoftwareReleases TO cms_hltdev_writer;
GRANT SELECT ON SoftwareSubsystems TO cms_hltdev_writer;
GRANT SELECT ON SoftwarePackages TO cms_hltdev_writer;
GRANT SELECT ON ConfigurationPathAssoc TO cms_hltdev_writer;
GRANT SELECT ON StreamPathAssoc TO cms_hltdev_writer;
GRANT SELECT ON ConfigurationStreamAssoc TO cms_hltdev_writer;
GRANT SELECT ON PrimaryDatasetPathAssoc TO cms_hltdev_writer;
GRANT SELECT ON PathInPathAssoc TO cms_hltdev_writer;
GRANT SELECT ON PathModuleAssoc TO cms_hltdev_writer;
GRANT SELECT ON ConfigurationSequenceAssoc TO cms_hltdev_writer;
GRANT SELECT ON PathSequenceAssoc TO cms_hltdev_writer;
GRANT SELECT ON SequenceInSequenceAssoc TO cms_hltdev_writer;
GRANT SELECT ON SequenceModuleAssoc TO cms_hltdev_writer;
GRANT SELECT ON ConfigurationServiceAssoc TO cms_hltdev_writer;
GRANT SELECT ON ConfigurationEDSourceAssoc TO cms_hltdev_writer;
GRANT SELECT ON ConfigurationESSourceAssoc TO cms_hltdev_writer;
GRANT SELECT ON ConfigurationESModuleAssoc TO cms_hltdev_writer;
GRANT SELECT ON ConfigurationParamSetAssoc TO cms_hltdev_writer;
GRANT SELECT ON Paths TO cms_hltdev_writer;
GRANT SELECT ON Sequences TO cms_hltdev_writer;
GRANT SELECT ON Services TO cms_hltdev_writer;
GRANT SELECT ON ServiceTemplates TO cms_hltdev_writer;
GRANT SELECT ON EDSources TO cms_hltdev_writer;
GRANT SELECT ON EDSourceTemplates TO cms_hltdev_writer;
GRANT SELECT ON ESSources TO cms_hltdev_writer;
GRANT SELECT ON ESSourceTemplates TO cms_hltdev_writer;
GRANT SELECT ON ESModules TO cms_hltdev_writer;
GRANT SELECT ON ESModuleTemplates TO cms_hltdev_writer;
GRANT SELECT ON Modules TO cms_hltdev_writer;
GRANT SELECT ON ModuleTemplates TO cms_hltdev_writer;
GRANT SELECT ON ModuleTypes TO cms_hltdev_writer;
GRANT SELECT ON Configurations TO cms_hltdev_writer;
GRANT SELECT ON LockedConfigurations TO cms_hltdev_writer;
GRANT SELECT ON Streams TO cms_hltdev_writer;
GRANT SELECT ON PrimaryDatasets TO cms_hltdev_writer;
GRANT SELECT ON Directories TO cms_hltdev_writer;
GRANT SELECT ON Int32ParamValues TO cms_hltdev_writer;
GRANT SELECT ON VInt32ParamValues TO cms_hltdev_writer;
GRANT SELECT ON UInt32ParamValues TO cms_hltdev_writer;
GRANT SELECT ON VUInt32ParamValues TO cms_hltdev_writer;
GRANT SELECT ON Int64ParamValues TO cms_hltdev_writer;
GRANT SELECT ON VInt64ParamValues TO cms_hltdev_writer;
GRANT SELECT ON UInt64ParamValues TO cms_hltdev_writer;
GRANT SELECT ON VUInt64ParamValues TO cms_hltdev_writer;
GRANT SELECT ON BoolParamValues TO cms_hltdev_writer;
GRANT SELECT ON DoubleParamValues TO cms_hltdev_writer;
GRANT SELECT ON VDoubleParamValues TO cms_hltdev_writer;
GRANT SELECT ON StringParamValues TO cms_hltdev_writer;
GRANT SELECT ON VStringParamValues TO cms_hltdev_writer;
GRANT SELECT ON InputTagParamValues TO cms_hltdev_writer;
GRANT SELECT ON VInputTagParamValues TO cms_hltdev_writer;
GRANT SELECT ON EventIDParamValues TO cms_hltdev_writer;
GRANT SELECT ON VEventIDParamValues TO cms_hltdev_writer;
GRANT SELECT ON FileInPathParamValues TO cms_hltdev_writer;
GRANT SELECT ON SuperIdParameterAssoc TO cms_hltdev_writer;
GRANT SELECT ON SuperIdParamSetAssoc TO cms_hltdev_writer;
GRANT SELECT ON SuperIdVecParamSetAssoc TO cms_hltdev_writer;
GRANT SELECT ON ParameterSets TO cms_hltdev_writer;
GRANT SELECT ON VecParameterSets TO cms_hltdev_writer;
GRANT SELECT ON Parameters TO cms_hltdev_writer;
GRANT SELECT ON SuperIds TO cms_hltdev_writer;
GRANT SELECT ON ParameterTypes TO cms_hltdev_writer;
GRANT SELECT ON ReleaseId_Sequence TO cms_hltdev_writer;
GRANT SELECT ON SubsysId_Sequence TO cms_hltdev_writer;
GRANT SELECT ON PackageId_Sequence TO cms_hltdev_writer;
GRANT SELECT ON DirId_Sequence TO cms_hltdev_writer;
GRANT SELECT ON ConfigId_Sequence TO cms_hltdev_writer;
GRANT SELECT ON StreamId_Sequence TO cms_hltdev_writer;
GRANT SELECT ON DatasetId_Sequence TO cms_hltdev_writer;
GRANT SELECT ON SuperId_Sequence TO cms_hltdev_writer;
GRANT SELECT ON PathId_Sequence TO cms_hltdev_writer;
GRANT SELECT ON SequenceId_Sequence TO cms_hltdev_writer;
GRANT SELECT ON ParamId_Sequence TO cms_hltdev_writer;
-- INSERT
GRANT INSERT ON SuperIdReleaseAssoc TO cms_hltdev_writer;
GRANT INSERT ON ConfigurationPathAssoc TO cms_hltdev_writer;
GRANT INSERT ON StreamPathAssoc TO cms_hltdev_writer;
GRANT INSERT ON ConfigurationStreamAssoc TO cms_hltdev_writer;
GRANT INSERT ON PrimaryDatasetPathAssoc TO cms_hltdev_writer;
GRANT INSERT ON PathInPathAssoc TO cms_hltdev_writer;
GRANT INSERT ON PathModuleAssoc TO cms_hltdev_writer;
GRANT INSERT ON ConfigurationSequenceAssoc TO cms_hltdev_writer;
GRANT INSERT ON PathSequenceAssoc TO cms_hltdev_writer;
GRANT INSERT ON SequenceInSequenceAssoc TO cms_hltdev_writer;
GRANT INSERT ON SequenceModuleAssoc TO cms_hltdev_writer;
GRANT INSERT ON ConfigurationServiceAssoc TO cms_hltdev_writer;
GRANT INSERT ON ConfigurationEDSourceAssoc TO cms_hltdev_writer;
GRANT INSERT ON ConfigurationESSourceAssoc TO cms_hltdev_writer;
GRANT INSERT ON ConfigurationESModuleAssoc TO cms_hltdev_writer;
GRANT INSERT ON ConfigurationParamSetAssoc TO cms_hltdev_writer;
GRANT INSERT ON Paths TO cms_hltdev_writer;
GRANT INSERT ON Sequences TO cms_hltdev_writer;
GRANT INSERT ON Services TO cms_hltdev_writer;
GRANT INSERT ON EDSources TO cms_hltdev_writer;
GRANT INSERT ON ESSources TO cms_hltdev_writer;
GRANT INSERT ON ESModules TO cms_hltdev_writer;
GRANT INSERT ON Modules TO cms_hltdev_writer;
GRANT INSERT ON Configurations TO cms_hltdev_writer;
GRANT INSERT ON LockedConfigurations TO cms_hltdev_writer;
GRANT INSERT ON Streams TO cms_hltdev_writer;
GRANT INSERT ON PrimaryDatasets TO cms_hltdev_writer;
GRANT INSERT ON Directories TO cms_hltdev_writer;
GRANT INSERT ON Int32ParamValues TO cms_hltdev_writer;
GRANT INSERT ON VInt32ParamValues TO cms_hltdev_writer;
GRANT INSERT ON UInt32ParamValues TO cms_hltdev_writer;
GRANT INSERT ON VUInt32ParamValues TO cms_hltdev_writer;
GRANT INSERT ON Int64ParamValues TO cms_hltdev_writer;
GRANT INSERT ON VInt64ParamValues TO cms_hltdev_writer;
GRANT INSERT ON UInt64ParamValues TO cms_hltdev_writer;
GRANT INSERT ON VUInt64ParamValues TO cms_hltdev_writer;
GRANT INSERT ON BoolParamValues TO cms_hltdev_writer;
GRANT INSERT ON DoubleParamValues TO cms_hltdev_writer;
GRANT INSERT ON VDoubleParamValues TO cms_hltdev_writer;
GRANT INSERT ON StringParamValues TO cms_hltdev_writer;
GRANT INSERT ON VStringParamValues TO cms_hltdev_writer;
GRANT INSERT ON InputTagParamValues TO cms_hltdev_writer;
GRANT INSERT ON VInputTagParamValues TO cms_hltdev_writer;
GRANT INSERT ON EventIDParamValues TO cms_hltdev_writer;
GRANT INSERT ON VEventIDParamValues TO cms_hltdev_writer;
GRANT INSERT ON FileInPathParamValues TO cms_hltdev_writer;
GRANT INSERT ON SuperIdParameterAssoc TO cms_hltdev_writer;
GRANT INSERT ON SuperIdParamSetAssoc TO cms_hltdev_writer;
GRANT INSERT ON SuperIdVecParamSetAssoc TO cms_hltdev_writer;
GRANT INSERT ON ParameterSets TO cms_hltdev_writer;
GRANT INSERT ON VecParameterSets TO cms_hltdev_writer;
GRANT INSERT ON Parameters TO cms_hltdev_writer;
GRANT INSERT ON SuperIds TO cms_hltdev_writer;
-- DELETE
GRANT DELETE ON Directories TO cms_hltdev_writer;
GRANT DELETE ON LockedConfigurations TO cms_hltdev_writer;
-- EXECUTE
GRANT EXECUTE ON load_parameter_value TO cms_hltdev_writer;
GRANT EXECUTE ON load_parameters TO cms_hltdev_writer;
GRANT EXECUTE ON load_template TO cms_hltdev_writer;
GRANT EXECUTE ON load_templates TO cms_hltdev_writer;
GRANT EXECUTE ON load_templates_for_config TO cms_hltdev_writer;
GRANT EXECUTE ON load_configuration TO cms_hltdev_writer;
GRANT SELECT ON tmp_template_table TO cms_hltdev_writer;
GRANT SELECT ON tmp_instance_table TO cms_hltdev_writer;
GRANT SELECT ON tmp_parameter_table TO cms_hltdev_writer;
GRANT SELECT ON tmp_boolean_table TO cms_hltdev_writer;
GRANT SELECT ON tmp_int_table TO cms_hltdev_writer;
GRANT SELECT ON tmp_real_table TO cms_hltdev_writer;
GRANT SELECT ON tmp_string_table TO cms_hltdev_writer;
GRANT SELECT ON tmp_path_entries TO cms_hltdev_writer;
GRANT SELECT ON tmp_sequence_entries TO cms_hltdev_writer;
--
-- cms_hltdev_reader
--
-- SELECT
GRANT SELECT ON SuperIdReleaseAssoc TO cms_hltdev_reader;
GRANT SELECT ON SoftwareReleases TO cms_hltdev_reader;
GRANT SELECT ON SoftwareSubsystems TO cms_hltdev_reader;
GRANT SELECT ON SoftwarePackages TO cms_hltdev_reader;
GRANT SELECT ON ConfigurationPathAssoc TO cms_hltdev_reader;
GRANT SELECT ON StreamPathAssoc TO cms_hltdev_reader;
GRANT SELECT ON ConfigurationStreamAssoc TO cms_hltdev_reader;
GRANT SELECT ON PrimaryDatasetPathAssoc TO cms_hltdev_reader;
GRANT SELECT ON PathInPathAssoc TO cms_hltdev_reader;
GRANT SELECT ON PathModuleAssoc TO cms_hltdev_reader;
GRANT SELECT ON ConfigurationSequenceAssoc TO cms_hltdev_reader;
GRANT SELECT ON PathSequenceAssoc TO cms_hltdev_reader;
GRANT SELECT ON SequenceInSequenceAssoc TO cms_hltdev_reader;
GRANT SELECT ON SequenceModuleAssoc TO cms_hltdev_reader;
GRANT SELECT ON ConfigurationServiceAssoc TO cms_hltdev_reader;
GRANT SELECT ON ConfigurationEDSourceAssoc TO cms_hltdev_reader;
GRANT SELECT ON ConfigurationESSourceAssoc TO cms_hltdev_reader;
GRANT SELECT ON ConfigurationESModuleAssoc TO cms_hltdev_reader;
GRANT SELECT ON ConfigurationParamSetAssoc TO cms_hltdev_reader;
GRANT SELECT ON Paths TO cms_hltdev_reader;
GRANT SELECT ON Sequences TO cms_hltdev_reader;
GRANT SELECT ON Services TO cms_hltdev_reader;
GRANT SELECT ON ServiceTemplates TO cms_hltdev_reader;
GRANT SELECT ON EDSources TO cms_hltdev_reader;
GRANT SELECT ON EDSourceTemplates TO cms_hltdev_reader;
GRANT SELECT ON ESSources TO cms_hltdev_reader;
GRANT SELECT ON ESSourceTemplates TO cms_hltdev_reader;
GRANT SELECT ON ESModules TO cms_hltdev_reader;
GRANT SELECT ON ESModuleTemplates TO cms_hltdev_reader;
GRANT SELECT ON Modules TO cms_hltdev_reader;
GRANT SELECT ON ModuleTemplates TO cms_hltdev_reader;
GRANT SELECT ON ModuleTypes TO cms_hltdev_reader;
GRANT SELECT ON Configurations TO cms_hltdev_reader;
GRANT SELECT ON LockedConfigurations TO cms_hltdev_reader;
GRANT SELECT ON Streams TO cms_hltdev_reader;
GRANT SELECT ON PrimaryDatasets TO cms_hltdev_reader;
GRANT SELECT ON Directories TO cms_hltdev_reader;
GRANT SELECT ON Int32ParamValues TO cms_hltdev_reader;
GRANT SELECT ON VInt32ParamValues TO cms_hltdev_reader;
GRANT SELECT ON UInt32ParamValues TO cms_hltdev_reader;
GRANT SELECT ON VUInt32ParamValues TO cms_hltdev_reader;
GRANT SELECT ON Int64ParamValues TO cms_hltdev_reader;
GRANT SELECT ON VInt64ParamValues TO cms_hltdev_reader;
GRANT SELECT ON UInt64ParamValues TO cms_hltdev_reader;
GRANT SELECT ON VUInt64ParamValues TO cms_hltdev_reader;
GRANT SELECT ON BoolParamValues TO cms_hltdev_reader;
GRANT SELECT ON DoubleParamValues TO cms_hltdev_reader;
GRANT SELECT ON VDoubleParamValues TO cms_hltdev_reader;
GRANT SELECT ON StringParamValues TO cms_hltdev_reader;
GRANT SELECT ON VStringParamValues TO cms_hltdev_reader;
GRANT SELECT ON InputTagParamValues TO cms_hltdev_reader;
GRANT SELECT ON VInputTagParamValues TO cms_hltdev_reader;
GRANT SELECT ON EventIDParamValues TO cms_hltdev_reader;
GRANT SELECT ON VEventIDParamValues TO cms_hltdev_reader;
GRANT SELECT ON FileInPathParamValues TO cms_hltdev_reader;
GRANT SELECT ON SuperIdParameterAssoc TO cms_hltdev_reader;
GRANT SELECT ON SuperIdParamSetAssoc TO cms_hltdev_reader;
GRANT SELECT ON SuperIdVecParamSetAssoc TO cms_hltdev_reader;
GRANT SELECT ON ParameterSets TO cms_hltdev_reader;
GRANT SELECT ON VecParameterSets TO cms_hltdev_reader;
GRANT SELECT ON Parameters TO cms_hltdev_reader;
GRANT SELECT ON SuperIds TO cms_hltdev_reader;
GRANT SELECT ON ParameterTypes TO cms_hltdev_reader;
GRANT SELECT ON ReleaseId_Sequence TO cms_hltdev_reader;
GRANT SELECT ON SubsysId_Sequence TO cms_hltdev_reader;
GRANT SELECT ON PackageId_Sequence TO cms_hltdev_reader;
GRANT SELECT ON DirId_Sequence TO cms_hltdev_reader;
GRANT SELECT ON ConfigId_Sequence TO cms_hltdev_reader;
GRANT SELECT ON StreamId_Sequence TO cms_hltdev_reader;
GRANT SELECT ON DatasetId_Sequence TO cms_hltdev_reader;
GRANT SELECT ON SuperId_Sequence TO cms_hltdev_reader;
GRANT SELECT ON PathId_Sequence TO cms_hltdev_reader;
GRANT SELECT ON SequenceId_Sequence TO cms_hltdev_reader;
GRANT SELECT ON ParamId_Sequence TO cms_hltdev_reader;
-- INSERT
-- DELETE
-- EXECUTE
GRANT EXECUTE ON load_parameter_value TO cms_hltdev_reader;
GRANT EXECUTE ON load_parameters TO cms_hltdev_reader;
GRANT EXECUTE ON load_template TO cms_hltdev_reader;
GRANT EXECUTE ON load_templates TO cms_hltdev_reader;
GRANT EXECUTE ON load_templates_for_config TO cms_hltdev_reader;
GRANT EXECUTE ON load_configuration TO cms_hltdev_reader;
GRANT SELECT ON tmp_template_table TO cms_hltdev_reader;
GRANT SELECT ON tmp_instance_table TO cms_hltdev_reader;
GRANT SELECT ON tmp_parameter_table TO cms_hltdev_reader;
GRANT SELECT ON tmp_boolean_table TO cms_hltdev_reader;
GRANT SELECT ON tmp_int_table TO cms_hltdev_reader;
GRANT SELECT ON tmp_real_table TO cms_hltdev_reader;
GRANT SELECT ON tmp_string_table TO cms_hltdev_reader;
GRANT SELECT ON tmp_path_entries TO cms_hltdev_reader;
GRANT SELECT ON tmp_sequence_entries TO cms_hltdev_reader;