PageRenderTime 20ms CodeModel.GetById 13ms app.highlight 3ms RepoModel.GetById 2ms app.codeStats 0ms

/DetectorDescription/OnlineDBLoader/scripts/CMS_DTCTR_GEOMETRY_OWNER/CMS_DTCTR_GEOMETRY_OWNER.grt

https://github.com/aivanov-cern/cmssw
Groovy | 310 lines | 206 code | 104 blank | 0 comment | 1 complexity | 518fb5fead803c3f9c9118d157551c7f MD5 | raw file
  1-- D:\CMS-PROJECTS\Detector_Geometry_DB\CMS_DTCTR_GEOMETRY_OWNER.grt
  2--
  3-- Generated for Oracle 9i on Mon May 16  16:13:16 2005 by Server Generator 9.0.2.92.10
  4 
  5
  6PROMPT Granting Object Privileges
  7GRANT SELECT ON ZSEC_SEQ TO CMS_YLG_CORE_MANAGEMNT_WRITER
  8/
  9
 10GRANT SELECT ON ZSEC_SEQ TO CMS_YLG_DTCTR_GEOMETRY_WRITER
 11/
 12
 13GRANT INSERT, UPDATE ON SOLIDS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
 14/
 15
 16GRANT DELETE ON SOLIDS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
 17/
 18
 19GRANT SELECT ON SOLIDS TO CMS_YLG_DTCTR_GEOMETRY_READER
 20/
 21
 22GRANT DELETE ON MATERIALS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
 23/
 24
 25GRANT INSERT, UPDATE ON MATERIALS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
 26/
 27
 28GRANT SELECT ON MATERIALS TO CMS_YLG_DTCTR_GEOMETRY_READER
 29/
 30
 31GRANT DELETE ON TUBES TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
 32/
 33
 34GRANT INSERT, UPDATE ON TUBES TO CMS_YLG_DTCTR_GEOMETRY_WRITER
 35/
 36
 37GRANT SELECT ON TUBES TO CMS_YLG_DTCTR_GEOMETRY_READER
 38/
 39
 40GRANT DELETE ON RELPLACEMENTS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
 41/
 42
 43GRANT INSERT, UPDATE ON RELPLACEMENTS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
 44/
 45
 46GRANT SELECT ON RELPLACEMENTS TO CMS_YLG_DTCTR_GEOMETRY_READER
 47/
 48
 49GRANT INSERT, UPDATE ON BOXES TO CMS_YLG_DTCTR_GEOMETRY_WRITER
 50/
 51
 52GRANT SELECT ON BOXES TO CMS_YLG_DTCTR_GEOMETRY_READER
 53/
 54
 55GRANT DELETE ON BOXES TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
 56/
 57
 58GRANT SELECT ON MATERIALFRACTIONS TO CMS_YLG_DTCTR_GEOMETRY_READER
 59/
 60
 61GRANT INSERT, UPDATE ON MATERIALFRACTIONS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
 62/
 63
 64GRANT DELETE ON MATERIALFRACTIONS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
 65/
 66
 67GRANT DELETE ON CONES TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
 68/
 69
 70GRANT SELECT ON CONES TO CMS_YLG_DTCTR_GEOMETRY_READER
 71/
 72
 73GRANT INSERT, UPDATE ON CONES TO CMS_YLG_DTCTR_GEOMETRY_WRITER
 74/
 75
 76GRANT INSERT, UPDATE ON TRD1S TO CMS_YLG_DTCTR_GEOMETRY_WRITER
 77/
 78
 79GRANT SELECT ON TRD1S TO CMS_YLG_DTCTR_GEOMETRY_READER
 80/
 81
 82GRANT DELETE ON TRD1S TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
 83/
 84
 85GRANT INSERT, UPDATE ON PSEUDOTRAPEZOIDS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
 86/
 87
 88GRANT DELETE ON PSEUDOTRAPEZOIDS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
 89/
 90
 91GRANT SELECT ON PSEUDOTRAPEZOIDS TO CMS_YLG_DTCTR_GEOMETRY_READER
 92/
 93
 94GRANT INSERT, UPDATE ON SHAPELESSSOLIDS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
 95/
 96
 97GRANT SELECT ON SHAPELESSSOLIDS TO CMS_YLG_DTCTR_GEOMETRY_READER
 98/
 99
100GRANT DELETE ON SHAPELESSSOLIDS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
101/
102
103GRANT DELETE ON PHYSICALPARTSTREE TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
104/
105
106GRANT REFERENCES, SELECT ON PHYSICALPARTSTREE TO CMS_YLG_CORE_CONSTRUCT_OWNER
107/
108
109GRANT INSERT, UPDATE ON PHYSICALPARTSTREE TO CMS_YLG_DTCTR_GEOMETRY_WRITER
110/
111
112GRANT SELECT ON PHYSICALPARTSTREE TO CMS_YLG_DTCTR_GEOMETRY_READER
113/
114
115GRANT REFERENCES, SELECT ON PHYSICALPARTSTREE TO CMS_YLG_CORE_CONDITION_OWNER
116/
117
118GRANT DELETE ON POSPARTSGRAPH TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
119/
120
121GRANT SELECT ON POSPARTSGRAPH TO CMS_YLG_DTCTR_GEOMETRY_READER
122/
123
124GRANT INSERT, UPDATE ON POSPARTSGRAPH TO CMS_YLG_DTCTR_GEOMETRY_WRITER
125/
126
127GRANT INSERT, UPDATE ON CATEGORIES TO CMS_YLG_DTCTR_GEOMETRY_WRITER
128/
129
130GRANT SELECT ON CATEGORIES TO CMS_YLG_DTCTR_GEOMETRY_READER
131/
132
133GRANT DELETE ON CATEGORIES TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
134/
135
136GRANT SELECT ON TRAPEZOIDS TO CMS_YLG_DTCTR_GEOMETRY_READER
137/
138
139GRANT INSERT, UPDATE ON TRAPEZOIDS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
140/
141
142GRANT DELETE ON TRAPEZOIDS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
143/
144
145GRANT INSERT, UPDATE ON POLYHEDRA TO CMS_YLG_DTCTR_GEOMETRY_WRITER
146/
147
148GRANT SELECT ON POLYHEDRA TO CMS_YLG_DTCTR_GEOMETRY_READER
149/
150
151GRANT DELETE ON POLYHEDRA TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
152/
153
154GRANT SELECT ON LOGICALPARTTYPES TO CMS_YLG_DTCTR_GEOMETRY_READER
155/
156
157GRANT INSERT, UPDATE ON LOGICALPARTTYPES TO CMS_YLG_DTCTR_GEOMETRY_WRITER
158/
159
160GRANT DELETE ON LOGICALPARTTYPES TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
161/
162
163GRANT REFERENCES, SELECT ON LOGICALPARTTYPES TO CMS_YLG_CORE_CONSTRUCT_OWNER
164/
165
166GRANT REFERENCES, SELECT ON LOGICALPARTTYPES TO CMS_YLG_CORE_CONDITION_OWNER
167/
168
169GRANT INSERT, UPDATE ON BOOLEANSOLIDS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
170/
171
172GRANT SELECT ON BOOLEANSOLIDS TO CMS_YLG_DTCTR_GEOMETRY_READER
173/
174
175GRANT DELETE ON BOOLEANSOLIDS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
176/
177
178GRANT INSERT, UPDATE ON RZPOINTS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
179/
180
181GRANT DELETE ON RZPOINTS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
182/
183
184GRANT SELECT ON RZPOINTS TO CMS_YLG_DTCTR_GEOMETRY_READER
185/
186
187GRANT SELECT ON TUBESECTIONS TO CMS_YLG_DTCTR_GEOMETRY_READER
188/
189
190GRANT INSERT, UPDATE ON TUBESECTIONS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
191/
192
193GRANT DELETE ON TUBESECTIONS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
194/
195
196GRANT INSERT, UPDATE ON SPECIFICPARTS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
197/
198
199GRANT SELECT ON SPECIFICPARTS TO CMS_YLG_DTCTR_GEOMETRY_READER
200/
201
202GRANT DELETE ON SPECIFICPARTS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
203/
204
205GRANT INSERT, UPDATE ON POLYCONES TO CMS_YLG_DTCTR_GEOMETRY_WRITER
206/
207
208GRANT DELETE ON POLYCONES TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
209/
210
211GRANT SELECT ON POLYCONES TO CMS_YLG_DTCTR_GEOMETRY_READER
212/
213
214GRANT SELECT ON NOMINALPLACEMENTS TO CMS_YLG_DTCTR_GEOMETRY_READER
215/
216
217GRANT INSERT, UPDATE ON NOMINALPLACEMENTS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
218/
219
220GRANT DELETE ON NOMINALPLACEMENTS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
221/
222
223GRANT DELETE ON ROTATIONS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
224/
225
226GRANT INSERT, UPDATE ON ROTATIONS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
227/
228
229GRANT SELECT ON ROTATIONS TO CMS_YLG_DTCTR_GEOMETRY_READER
230/
231
232GRANT DELETE ON DETECTORPARTS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
233/
234
235GRANT INSERT, UPDATE ON DETECTORPARTS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
236/
237
238GRANT SELECT ON DETECTORPARTS TO CMS_YLG_DTCTR_GEOMETRY_READER
239/
240
241GRANT INSERT, UPDATE ON COMPOSITEMATERIALS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
242/
243
244GRANT DELETE ON COMPOSITEMATERIALS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
245/
246
247GRANT SELECT ON COMPOSITEMATERIALS TO CMS_YLG_DTCTR_GEOMETRY_READER
248/
249
250GRANT DELETE ON ZSECTIONS TO CMS_YLG_CORE_MANAGEMNT_ADMIN
251/
252
253GRANT DELETE ON ZSECTIONS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
254/
255
256GRANT INSERT, UPDATE ON ZSECTIONS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
257/
258
259GRANT SELECT ON ZSECTIONS TO CMS_YLG_DTCTR_GEOMETRY_READER
260/
261
262GRANT INSERT, UPDATE ON ZSECTIONS TO CMS_YLG_CORE_MANAGEMNT_WRITER
263/
264
265GRANT SELECT ON REFLECTIONSOLIDS TO CMS_YLG_DTCTR_GEOMETRY_READER
266/
267
268GRANT INSERT, UPDATE ON REFLECTIONSOLIDS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
269/
270
271GRANT DELETE ON REFLECTIONSOLIDS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
272/
273
274GRANT DELETE ON ELEMENTARYMATERIALS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
275/
276
277GRANT SELECT ON ELEMENTARYMATERIALS TO CMS_YLG_DTCTR_GEOMETRY_READER
278/
279
280GRANT INSERT, UPDATE ON ELEMENTARYMATERIALS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
281/
282
283GRANT INSERT, UPDATE ON LOGICALPARTSVIEW TO CMS_YLG_DTCTR_GEOMETRY_WRITER
284/
285
286GRANT SELECT ON LOGICALPARTSVIEW TO CMS_YLG_DTCTR_GEOMETRY_READER
287/
288
289GRANT DELETE ON LOGICALPARTSVIEW TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
290/
291
292GRANT INSERT, UPDATE ON PHYSICALPARTSVIEW TO CMS_YLG_DTCTR_GEOMETRY_WRITER
293/
294
295GRANT SELECT ON PHYSICALPARTSVIEW TO CMS_YLG_DTCTR_GEOMETRY_READER
296/
297
298GRANT DELETE ON PHYSICALPARTSVIEW TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
299/
300
301GRANT INSERT, UPDATE ON POSPARTSVIEW TO CMS_YLG_DTCTR_GEOMETRY_WRITER
302/
303
304GRANT DELETE ON POSPARTSVIEW TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
305/
306
307GRANT SELECT ON POSPARTSVIEW TO CMS_YLG_DTCTR_GEOMETRY_READER
308/
309
310