/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. PROMPT Granting Object Privileges
  5. GRANT SELECT ON ZSEC_SEQ TO CMS_YLG_CORE_MANAGEMNT_WRITER
  6. /
  7. GRANT SELECT ON ZSEC_SEQ TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  8. /
  9. GRANT INSERT, UPDATE ON SOLIDS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  10. /
  11. GRANT DELETE ON SOLIDS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  12. /
  13. GRANT SELECT ON SOLIDS TO CMS_YLG_DTCTR_GEOMETRY_READER
  14. /
  15. GRANT DELETE ON MATERIALS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  16. /
  17. GRANT INSERT, UPDATE ON MATERIALS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  18. /
  19. GRANT SELECT ON MATERIALS TO CMS_YLG_DTCTR_GEOMETRY_READER
  20. /
  21. GRANT DELETE ON TUBES TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  22. /
  23. GRANT INSERT, UPDATE ON TUBES TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  24. /
  25. GRANT SELECT ON TUBES TO CMS_YLG_DTCTR_GEOMETRY_READER
  26. /
  27. GRANT DELETE ON RELPLACEMENTS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  28. /
  29. GRANT INSERT, UPDATE ON RELPLACEMENTS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  30. /
  31. GRANT SELECT ON RELPLACEMENTS TO CMS_YLG_DTCTR_GEOMETRY_READER
  32. /
  33. GRANT INSERT, UPDATE ON BOXES TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  34. /
  35. GRANT SELECT ON BOXES TO CMS_YLG_DTCTR_GEOMETRY_READER
  36. /
  37. GRANT DELETE ON BOXES TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  38. /
  39. GRANT SELECT ON MATERIALFRACTIONS TO CMS_YLG_DTCTR_GEOMETRY_READER
  40. /
  41. GRANT INSERT, UPDATE ON MATERIALFRACTIONS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  42. /
  43. GRANT DELETE ON MATERIALFRACTIONS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  44. /
  45. GRANT DELETE ON CONES TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  46. /
  47. GRANT SELECT ON CONES TO CMS_YLG_DTCTR_GEOMETRY_READER
  48. /
  49. GRANT INSERT, UPDATE ON CONES TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  50. /
  51. GRANT INSERT, UPDATE ON TRD1S TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  52. /
  53. GRANT SELECT ON TRD1S TO CMS_YLG_DTCTR_GEOMETRY_READER
  54. /
  55. GRANT DELETE ON TRD1S TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  56. /
  57. GRANT INSERT, UPDATE ON PSEUDOTRAPEZOIDS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  58. /
  59. GRANT DELETE ON PSEUDOTRAPEZOIDS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  60. /
  61. GRANT SELECT ON PSEUDOTRAPEZOIDS TO CMS_YLG_DTCTR_GEOMETRY_READER
  62. /
  63. GRANT INSERT, UPDATE ON SHAPELESSSOLIDS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  64. /
  65. GRANT SELECT ON SHAPELESSSOLIDS TO CMS_YLG_DTCTR_GEOMETRY_READER
  66. /
  67. GRANT DELETE ON SHAPELESSSOLIDS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  68. /
  69. GRANT DELETE ON PHYSICALPARTSTREE TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  70. /
  71. GRANT REFERENCES, SELECT ON PHYSICALPARTSTREE TO CMS_YLG_CORE_CONSTRUCT_OWNER
  72. /
  73. GRANT INSERT, UPDATE ON PHYSICALPARTSTREE TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  74. /
  75. GRANT SELECT ON PHYSICALPARTSTREE TO CMS_YLG_DTCTR_GEOMETRY_READER
  76. /
  77. GRANT REFERENCES, SELECT ON PHYSICALPARTSTREE TO CMS_YLG_CORE_CONDITION_OWNER
  78. /
  79. GRANT DELETE ON POSPARTSGRAPH TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  80. /
  81. GRANT SELECT ON POSPARTSGRAPH TO CMS_YLG_DTCTR_GEOMETRY_READER
  82. /
  83. GRANT INSERT, UPDATE ON POSPARTSGRAPH TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  84. /
  85. GRANT INSERT, UPDATE ON CATEGORIES TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  86. /
  87. GRANT SELECT ON CATEGORIES TO CMS_YLG_DTCTR_GEOMETRY_READER
  88. /
  89. GRANT DELETE ON CATEGORIES TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  90. /
  91. GRANT SELECT ON TRAPEZOIDS TO CMS_YLG_DTCTR_GEOMETRY_READER
  92. /
  93. GRANT INSERT, UPDATE ON TRAPEZOIDS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  94. /
  95. GRANT DELETE ON TRAPEZOIDS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  96. /
  97. GRANT INSERT, UPDATE ON POLYHEDRA TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  98. /
  99. GRANT SELECT ON POLYHEDRA TO CMS_YLG_DTCTR_GEOMETRY_READER
  100. /
  101. GRANT DELETE ON POLYHEDRA TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  102. /
  103. GRANT SELECT ON LOGICALPARTTYPES TO CMS_YLG_DTCTR_GEOMETRY_READER
  104. /
  105. GRANT INSERT, UPDATE ON LOGICALPARTTYPES TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  106. /
  107. GRANT DELETE ON LOGICALPARTTYPES TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  108. /
  109. GRANT REFERENCES, SELECT ON LOGICALPARTTYPES TO CMS_YLG_CORE_CONSTRUCT_OWNER
  110. /
  111. GRANT REFERENCES, SELECT ON LOGICALPARTTYPES TO CMS_YLG_CORE_CONDITION_OWNER
  112. /
  113. GRANT INSERT, UPDATE ON BOOLEANSOLIDS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  114. /
  115. GRANT SELECT ON BOOLEANSOLIDS TO CMS_YLG_DTCTR_GEOMETRY_READER
  116. /
  117. GRANT DELETE ON BOOLEANSOLIDS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  118. /
  119. GRANT INSERT, UPDATE ON RZPOINTS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  120. /
  121. GRANT DELETE ON RZPOINTS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  122. /
  123. GRANT SELECT ON RZPOINTS TO CMS_YLG_DTCTR_GEOMETRY_READER
  124. /
  125. GRANT SELECT ON TUBESECTIONS TO CMS_YLG_DTCTR_GEOMETRY_READER
  126. /
  127. GRANT INSERT, UPDATE ON TUBESECTIONS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  128. /
  129. GRANT DELETE ON TUBESECTIONS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  130. /
  131. GRANT INSERT, UPDATE ON SPECIFICPARTS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  132. /
  133. GRANT SELECT ON SPECIFICPARTS TO CMS_YLG_DTCTR_GEOMETRY_READER
  134. /
  135. GRANT DELETE ON SPECIFICPARTS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  136. /
  137. GRANT INSERT, UPDATE ON POLYCONES TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  138. /
  139. GRANT DELETE ON POLYCONES TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  140. /
  141. GRANT SELECT ON POLYCONES TO CMS_YLG_DTCTR_GEOMETRY_READER
  142. /
  143. GRANT SELECT ON NOMINALPLACEMENTS TO CMS_YLG_DTCTR_GEOMETRY_READER
  144. /
  145. GRANT INSERT, UPDATE ON NOMINALPLACEMENTS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  146. /
  147. GRANT DELETE ON NOMINALPLACEMENTS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  148. /
  149. GRANT DELETE ON ROTATIONS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  150. /
  151. GRANT INSERT, UPDATE ON ROTATIONS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  152. /
  153. GRANT SELECT ON ROTATIONS TO CMS_YLG_DTCTR_GEOMETRY_READER
  154. /
  155. GRANT DELETE ON DETECTORPARTS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  156. /
  157. GRANT INSERT, UPDATE ON DETECTORPARTS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  158. /
  159. GRANT SELECT ON DETECTORPARTS TO CMS_YLG_DTCTR_GEOMETRY_READER
  160. /
  161. GRANT INSERT, UPDATE ON COMPOSITEMATERIALS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  162. /
  163. GRANT DELETE ON COMPOSITEMATERIALS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  164. /
  165. GRANT SELECT ON COMPOSITEMATERIALS TO CMS_YLG_DTCTR_GEOMETRY_READER
  166. /
  167. GRANT DELETE ON ZSECTIONS TO CMS_YLG_CORE_MANAGEMNT_ADMIN
  168. /
  169. GRANT DELETE ON ZSECTIONS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  170. /
  171. GRANT INSERT, UPDATE ON ZSECTIONS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  172. /
  173. GRANT SELECT ON ZSECTIONS TO CMS_YLG_DTCTR_GEOMETRY_READER
  174. /
  175. GRANT INSERT, UPDATE ON ZSECTIONS TO CMS_YLG_CORE_MANAGEMNT_WRITER
  176. /
  177. GRANT SELECT ON REFLECTIONSOLIDS TO CMS_YLG_DTCTR_GEOMETRY_READER
  178. /
  179. GRANT INSERT, UPDATE ON REFLECTIONSOLIDS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  180. /
  181. GRANT DELETE ON REFLECTIONSOLIDS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  182. /
  183. GRANT DELETE ON ELEMENTARYMATERIALS TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  184. /
  185. GRANT SELECT ON ELEMENTARYMATERIALS TO CMS_YLG_DTCTR_GEOMETRY_READER
  186. /
  187. GRANT INSERT, UPDATE ON ELEMENTARYMATERIALS TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  188. /
  189. GRANT INSERT, UPDATE ON LOGICALPARTSVIEW TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  190. /
  191. GRANT SELECT ON LOGICALPARTSVIEW TO CMS_YLG_DTCTR_GEOMETRY_READER
  192. /
  193. GRANT DELETE ON LOGICALPARTSVIEW TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  194. /
  195. GRANT INSERT, UPDATE ON PHYSICALPARTSVIEW TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  196. /
  197. GRANT SELECT ON PHYSICALPARTSVIEW TO CMS_YLG_DTCTR_GEOMETRY_READER
  198. /
  199. GRANT DELETE ON PHYSICALPARTSVIEW TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  200. /
  201. GRANT INSERT, UPDATE ON POSPARTSVIEW TO CMS_YLG_DTCTR_GEOMETRY_WRITER
  202. /
  203. GRANT DELETE ON POSPARTSVIEW TO CMS_YLG_DTCTR_GEOMETRY_ADMIN
  204. /
  205. GRANT SELECT ON POSPARTSVIEW TO CMS_YLG_DTCTR_GEOMETRY_READER
  206. /