/DetectorDescription/OnlineDBLoader/scripts/CMS_DTCTR_GEOMETRY_OWNER/CMS_DTCTR_GEOMETRY_OWNER.grt
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