← Back to branch summary

~launchpad-pqm/launchpad/devel

« back to all changes in this revision

Viewing changes to database/schema/security.cfg

  • Committer: Launchpad Patch Queue Manager
  • Date: 2011-09-21 03:09:33 UTC
  • mfrom: (7675.1045.811 db-devel)
  • Revision ID: launchpad@pqm.canonical.com-20110921030933-mfkdkkkb99sskvrt
Merging db-stable at revno 10994

Show diffs side-by-side

added added

removed removed

Lines of Context:
database/schema/security.cfg
115
115
public.archivejob                       = SELECT, INSERT, UPDATE, DELETE
116
116
public.archivepermission                = SELECT, INSERT, UPDATE, DELETE
117
117
public.archivesubscriber                = SELECT, INSERT, UPDATE
118
 
public.authtoken                        = SELECT, INSERT, UPDATE, DELETE
119
118
public.binaryandsourcepackagenameview   = SELECT
120
119
public.binarypackagepath                = SELECT, INSERT, DELETE
121
120
public.binarypackagepublishinghistory   = SELECT
122
121
public.binarypackagereleasecontents     = SELECT, INSERT, DELETE
123
122
public.binarypackagereleasedownloadcount= SELECT, INSERT, UPDATE
124
 
public.bountysubscription               = SELECT, INSERT, UPDATE, DELETE
125
123
public.branch                           = SELECT, INSERT, UPDATE, DELETE
126
124
public.branchjob                        = SELECT, INSERT, UPDATE, DELETE
127
125
public.branchmergeproposal              = SELECT, INSERT, UPDATE, DELETE
166
164
public.cvereference                     = SELECT, INSERT
167
165
public.databasereplicationlag           = SELECT
168
166
public.diff                             = SELECT, INSERT, UPDATE
169
 
public.distributionbounty               = SELECT, INSERT, UPDATE
170
167
public.distributionjob                  = SELECT, INSERT, DELETE
171
168
public.distributionmirror               = SELECT, INSERT, UPDATE, DELETE
172
169
public.distributionsourcepackage        = SELECT, INSERT, UPDATE, DELETE
214
211
public.libraryfiledownloadcount         = SELECT, INSERT, UPDATE
215
212
public.logintoken                       = SELECT, INSERT, UPDATE, DELETE
216
213
public.mailinglist                      = SELECT, INSERT, UPDATE, DELETE
217
 
public.mailinglistban                   = SELECT, INSERT, UPDATE, DELETE
218
214
public.mailinglistsubscription          = SELECT, INSERT, UPDATE, DELETE
219
 
public.mentoringoffer                   = SELECT, INSERT, UPDATE, DELETE
220
215
public.mergedirectivejob                = SELECT, INSERT, UPDATE, DELETE
221
216
public.messageapproval                  = SELECT, INSERT, UPDATE, DELETE
222
217
public.messagechunk                     = SELECT, INSERT
234
229
public.openidconsumerassociation        = SELECT, INSERT, UPDATE, DELETE
235
230
public.openidconsumernonce              = SELECT, INSERT, UPDATE
236
231
public.openididentifier                 = SELECT, INSERT, UPDATE, DELETE
237
 
public.packagebugsupervisor             = SELECT, INSERT, UPDATE, DELETE
238
232
public.packagebuild                     = DELETE
239
233
public.packagecopyjob                   = SELECT, INSERT, UPDATE
240
234
public.packagecopyrequest               = SELECT, INSERT, UPDATE
257
251
public.polloption                       = SELECT, INSERT, UPDATE, DELETE
258
252
public.potexport                        = SELECT
259
253
public.previewdiff                      = SELECT, INSERT, UPDATE, DELETE
260
 
public.productbounty                    = SELECT, INSERT, UPDATE
261
254
public.productrelease                   = SELECT, INSERT, UPDATE, DELETE
262
255
public.productreleasefile               = SELECT, INSERT, DELETE
263
 
public.productseriescodeimport          = SELECT, INSERT, UPDATE
264
256
public.project                          = SELECT
265
 
public.projectbounty                    = SELECT, INSERT, UPDATE
266
257
public.publisherconfig                  = SELECT, INSERT, UPDATE, DELETE
267
258
public.question                         = SELECT, INSERT, UPDATE
268
259
public.questionbug                      = SELECT, INSERT, DELETE
270
261
public.questionmessage                  = SELECT, INSERT
271
262
public.questionreopening                = SELECT, INSERT, UPDATE
272
263
public.questionsubscription             = SELECT, INSERT, UPDATE, DELETE
273
 
public.requestedcds                     = SELECT, INSERT, UPDATE, DELETE
274
264
public.revision                         = SELECT, INSERT, UPDATE
275
265
public.revisionauthor                   = SELECT, INSERT, UPDATE
276
266
public.revisioncache                    = SELECT, INSERT, UPDATE, DELETE
277
267
public.revisionparent                   = SELECT, INSERT
278
268
public.scriptactivity                   = SELECT
279
269
public.seriessourcepackagebranch        = SELECT, INSERT, UPDATE, DELETE
280
 
public.shipitreport                     = SELECT, INSERT
281
 
public.shipitsurvey                     = SELECT, INSERT, UPDATE
282
 
public.shipitsurveyanswer               = SELECT, INSERT
283
 
public.shipitsurveyquestion             = SELECT, INSERT
284
 
public.shipitsurveyresult               = SELECT, INSERT
285
 
public.shipment                         = SELECT, INSERT, UPDATE
286
 
public.shippingrequest                  = SELECT, INSERT, UPDATE, DELETE
287
 
public.shippingrun                      = SELECT, INSERT, UPDATE
288
270
public.sourcepackageformatselection     = SELECT
289
271
public.sourcepackagepublishinghistory   = SELECT
290
272
public.sourcepackagerecipe              = SELECT, INSERT, UPDATE, DELETE
304
286
public.sprint                           = SELECT, INSERT, UPDATE
305
287
public.sprintattendance                 = SELECT, INSERT, UPDATE, DELETE
306
288
public.sprintspecification              = SELECT, INSERT, UPDATE, DELETE
307
 
public.standardshipitrequest            = SELECT, INSERT, UPDATE, DELETE
308
289
public.structuralsubscription           = SELECT, INSERT, UPDATE, DELETE
309
290
public.subunitstream                    = SELECT, INSERT, UPDATE, DELETE
310
291
public.suggestivepotemplate             = SELECT, INSERT, DELETE
320
301
public.validpersonorteamcache           = SELECT
321
302
public.vote                             = SELECT, INSERT, UPDATE
322
303
public.votecast                         = SELECT, INSERT
323
 
public.webserviceban                    = SELECT, INSERT, UPDATE, DELETE
324
304
public.wikiname                         = SELECT, INSERT, UPDATE, DELETE
325
305
type=user
326
306
 
409
389
public.messageapproval                  = SELECT
410
390
public.messagechunk                     = SELECT
411
391
public.mirrorproberecord                = SELECT
412
 
public.openidrpconfig                   = SELECT
413
392
public.packagebuild                     = SELECT
414
393
public.packagediff                      = SELECT
415
394
public.packageupload                    = SELECT
421
400
public.product                          = SELECT
422
401
public.productreleasefile               = SELECT
423
402
public.project                          = SELECT
424
 
public.shipitreport                     = SELECT
425
 
public.shippingrun                      = SELECT
426
403
public.sourcepackagerecipebuild         = SELECT
427
404
public.sourcepackagerelease             = SELECT
428
405
public.sourcepackagereleasefile         = SELECT
593
570
public.message                          = SELECT, INSERT
594
571
public.messagechunk                     = SELECT, INSERT
595
572
public.milestone                        = SELECT
596
 
public.packagebugsupervisor             = SELECT
597
573
public.person                           = SELECT, INSERT, UPDATE
598
574
public.personlanguage                   = SELECT
599
575
public.personsettings                   = SELECT, INSERT
864
840
public.message                          = SELECT, INSERT
865
841
public.messagechunk                     = SELECT, INSERT
866
842
public.milestone                        = SELECT
867
 
public.packagebugsupervisor             = SELECT
868
843
public.packagecopyjob                   = SELECT, INSERT, DELETE
869
844
public.packagecopyrequest               = SELECT, INSERT, UPDATE
870
845
public.packagediff                      = SELECT, INSERT, UPDATE
1105
1080
public.binarypackagename                = SELECT, INSERT, UPDATE
1106
1081
public.binarypackagepublishinghistory   = SELECT, INSERT, UPDATE, DELETE
1107
1082
public.binarypackagerelease             = SELECT, INSERT, UPDATE
1108
 
public.bounty                           = SELECT, INSERT, UPDATE
1109
 
public.bountymessage                    = SELECT, INSERT
1110
1083
public.branch                           = SELECT, INSERT, UPDATE
1111
1084
public.bug                              = SELECT, INSERT, UPDATE
1112
1085
public.bugactivity                      = SELECT, INSERT, UPDATE
1115
1088
public.bugmessage                       = SELECT, INSERT, UPDATE
1116
1089
public.bugmute                          = SELECT, INSERT, UPDATE, DELETE
1117
1090
public.bugnomination                    = SELECT, INSERT, UPDATE
1118
 
public.bugpackageinfestation            = SELECT, INSERT, UPDATE
1119
 
public.bugproductinfestation            = SELECT, INSERT, UPDATE
1120
1091
public.bugsubscription                  = SELECT, INSERT, UPDATE, DELETE
1121
1092
public.bugsubscriptionfilter            = SELECT, INSERT, UPDATE, DELETE
1122
1093
public.bugsubscriptionfilterimportance  = SELECT, INSERT, UPDATE, DELETE
1137
1108
public.country                          = SELECT, INSERT, UPDATE
1138
1109
public.distribution                     = SELECT, INSERT, UPDATE
1139
1110
public.distroarchseries                 = SELECT, INSERT, UPDATE
1140
 
public.distrocomponentuploader          = SELECT, INSERT, UPDATE
1141
1111
public.distroseries                     = SELECT, INSERT, UPDATE
1142
1112
public.emailaddress                     = SELECT, INSERT, UPDATE
1143
1113
public.gpgkey                           = SELECT, INSERT, UPDATE, DELETE
1157
1127
public.mirrorcontent                    = SELECT, INSERT, UPDATE, DELETE
1158
1128
public.mirrorsourcecontent              = SELECT, INSERT, UPDATE, DELETE
1159
1129
public.packagebuild                     = SELECT, INSERT, UPDATE
1160
 
public.packageselection                 = SELECT, INSERT, UPDATE
1161
1130
public.packageupload                    = SELECT, INSERT, UPDATE
1162
1131
public.packageuploadbuild               = SELECT, INSERT, UPDATE
1163
1132
public.packageuploadcustom              = SELECT, INSERT, UPDATE
1167
1136
public.personlanguage                   = SELECT, INSERT, UPDATE
1168
1137
public.personsettings                   = SELECT, INSERT, UPDATE
1169
1138
public.pocketchroot                     = SELECT, INSERT, UPDATE
1170
 
public.pocomment                        = SELECT, INSERT, UPDATE
1171
1139
public.pofile                           = SELECT, INSERT, UPDATE
1172
1140
public.pofiletranslator                 = SELECT, INSERT, UPDATE
1173
1141
public.pomsgid                          = SELECT, INSERT, UPDATE
1174
 
public.posubscription                   = SELECT, INSERT, UPDATE, DELETE
1175
1142
public.potemplate                       = SELECT, INSERT, UPDATE
1176
1143
public.potmsgset                        = SELECT, INSERT, UPDATE
1177
1144
public.potranslation                    = SELECT, INSERT, UPDATE
1178
1145
public.processor                        = SELECT, INSERT, UPDATE
1179
1146
public.processorfamily                  = SELECT, INSERT, UPDATE
1180
1147
public.product                          = SELECT, INSERT, UPDATE
1181
 
public.productcvsmodule                 = SELECT, INSERT, UPDATE
1182
1148
public.productlicense                   = SELECT, INSERT, UPDATE, DELETE
1183
1149
public.productrelease                   = SELECT, INSERT, UPDATE
1184
1150
public.productreleasefile               = SELECT, INSERT, UPDATE
1185
1151
public.productseries                    = SELECT, INSERT, UPDATE
1186
 
public.productsvnmodule                 = SELECT, INSERT, UPDATE
1187
1152
public.project                          = SELECT, INSERT, UPDATE
1188
 
public.projectrelationship              = SELECT, INSERT, UPDATE
1189
 
public.pushmirroraccess                 = SELECT, INSERT, UPDATE
1190
1153
public.section                          = SELECT, INSERT, UPDATE
1191
1154
public.sectionselection                 = SELECT, INSERT, UPDATE
1192
1155
public.signedcodeofconduct              = SELECT, INSERT, UPDATE
1205
1168
public.wikiname                         = SELECT, INSERT, UPDATE, DELETE
1206
1169
type=group
1207
1170
 
1208
 
[shipit]
1209
 
groups=script
1210
 
public.account                          = SELECT
1211
 
public.continent                        = SELECT
1212
 
public.country                          = SELECT
1213
 
public.emailaddress                     = SELECT
1214
 
public.karma                            = SELECT
1215
 
public.libraryfilealias                 = SELECT, INSERT
1216
 
public.libraryfilecontent               = SELECT, INSERT
1217
 
public.person                           = SELECT
1218
 
public.requestedcds                     = SELECT, INSERT, UPDATE
1219
 
public.shipitreport                     = SELECT, INSERT
1220
 
public.shipment                         = SELECT, INSERT
1221
 
public.shippingrequest                  = SELECT, UPDATE
1222
 
public.shippingrun                      = SELECT, INSERT, UPDATE
1223
 
public.standardshipitrequest            = SELECT
1224
 
public.validpersoncache                 = SELECT
1225
 
public.validpersonorteamcache           = SELECT
1226
 
type=user
1227
 
 
1228
1171
[standingupdater]
1229
1172
groups=script
1230
1173
public.emailaddress                     = SELECT
1313
1256
public.distributionjob                  = SELECT, INSERT
1314
1257
public.distributionsourcepackage        = SELECT, INSERT, UPDATE
1315
1258
public.distroarchseries                 = SELECT
1316
 
public.distrocomponentuploader          = SELECT
1317
1259
public.distroseries                     = SELECT, UPDATE
1318
1260
public.distroseriesparent               = SELECT
1319
1261
public.emailaddress                     = SELECT, INSERT, UPDATE
1328
1270
public.message                          = SELECT, INSERT
1329
1271
public.messagechunk                     = SELECT, INSERT
1330
1272
public.milestone                        = SELECT
1331
 
public.packagebugsupervisor             = SELECT
1332
1273
public.packagebuild                     = SELECT, INSERT, UPDATE
1333
1274
public.packagecopyjob                   = SELECT, INSERT
1334
1275
public.packagediff                      = SELECT, INSERT, UPDATE, DELETE
1417
1358
public.distributionjob                  = SELECT, INSERT
1418
1359
public.distributionsourcepackage        = SELECT, INSERT, UPDATE
1419
1360
public.distroarchseries                 = SELECT
1420
 
public.distrocomponentuploader          = SELECT
1421
1361
public.distroseries                     = SELECT
1422
1362
public.distroseriesdifference           = SELECT
1423
1363
public.distroseriesparent               = SELECT
1433
1373
public.message                          = SELECT, INSERT
1434
1374
public.messagechunk                     = SELECT, INSERT
1435
1375
public.milestone                        = SELECT
1436
 
public.packagebugsupervisor             = SELECT
1437
1376
public.packagebuild                     = SELECT, INSERT, UPDATE
1438
1377
public.packagecopyjob                   = SELECT, INSERT, UPDATE
1439
1378
public.packagediff                      = SELECT, UPDATE
1528
1467
public.message                          = SELECT, INSERT
1529
1468
public.messagechunk                     = SELECT, INSERT
1530
1469
public.milestone                        = SELECT
1531
 
public.packagebugsupervisor             = SELECT
1532
1470
public.person                           = SELECT
1533
1471
public.personlanguage                   = SELECT
1534
1472
public.personsettings                   = SELECT
1718
1656
public.distribution                     = SELECT, UPDATE
1719
1657
public.distributionsourcepackage        = SELECT, INSERT, UPDATE
1720
1658
public.distroarchseries                 = SELECT
1721
 
public.distrocomponentuploader          = SELECT
1722
1659
public.distroseries                     = SELECT
1723
1660
public.emailaddress                     = SELECT
1724
1661
public.faq                              = SELECT
1734
1671
public.message                          = SELECT, INSERT
1735
1672
public.messagechunk                     = SELECT, INSERT
1736
1673
public.milestone                        = SELECT
1737
 
public.packagebugsupervisor             = SELECT
1738
1674
public.packageset                       = SELECT
1739
1675
public.packagesetgroup                  = SELECT
1740
1676
public.packagesetinclusion              = SELECT
2022
1958
public.archivepermission                = SELECT, UPDATE
2023
1959
public.archivesubscriber                = SELECT, UPDATE
2024
1960
public.binarypackagepublishinghistory   = SELECT, UPDATE
2025
 
public.bounty                           = SELECT, UPDATE
2026
 
public.bountysubscription               = SELECT, UPDATE, DELETE
2027
1961
public.branch                           = SELECT, UPDATE
2028
1962
public.branchmergeproposal              = SELECT, UPDATE
2029
1963
public.branchmergequeue                 = SELECT, UPDATE
2036
1970
public.bugnomination                    = SELECT, UPDATE
2037
1971
public.bugnotificationrecipient         = SELECT, UPDATE, DELETE
2038
1972
public.bugnotificationrecipientarchive  = SELECT, UPDATE
2039
 
public.bugpackageinfestation            = SELECT, UPDATE
2040
 
public.bugproductinfestation            = SELECT, UPDATE
2041
1973
public.bugsubscription                  = SELECT, UPDATE
2042
1974
public.bugsubscriptionfilter            = SELECT, UPDATE, DELETE
2043
1975
public.bugsummary                       = SELECT
2055
1987
public.distribution                     = SELECT, UPDATE
2056
1988
public.distributionmirror               = SELECT, UPDATE
2057
1989
public.distroarchseries                 = SELECT, UPDATE
2058
 
public.distrocomponentuploader          = SELECT, UPDATE
2059
1990
public.distroseries                     = SELECT, UPDATE
2060
1991
public.emailaddress                     = SELECT, UPDATE, DELETE
2061
1992
public.entitlement                      = SELECT, UPDATE
2072
2003
public.karmatotalcache                  = SELECT, UPDATE, DELETE
2073
2004
public.logintoken                       = SELECT, UPDATE
2074
2005
public.mailinglist                      = SELECT, UPDATE
2075
 
public.mailinglistban                   = SELECT, UPDATE
2076
2006
public.mailinglistsubscription          = SELECT, DELETE
2077
 
public.mentoringoffer                   = SELECT, UPDATE
2078
2007
public.message                          = SELECT, UPDATE
2079
2008
public.messageapproval                  = SELECT, UPDATE
2080
2009
public.milestone                        = SELECT, UPDATE
2083
2012
public.oauthaccesstoken                 = SELECT, UPDATE
2084
2013
public.oauthrequesttoken                = SELECT, UPDATE
2085
2014
public.openididentifier                 = SELECT, UPDATE
2086
 
public.packagebugsupervisor             = SELECT, UPDATE
2087
2015
public.packagecopyrequest               = SELECT, UPDATE
2088
2016
public.packagediff                      = SELECT, UPDATE
2089
2017
public.packageset                       = SELECT, UPDATE
2095
2023
public.personnotification               = SELECT, INSERT, UPDATE
2096
2024
public.personsettings                   = SELECT, UPDATE
2097
2025
public.persontransferjob                = SELECT, INSERT, UPDATE
2098
 
public.pocomment                        = SELECT, UPDATE
2099
2026
public.poexportrequest                  = SELECT, UPDATE, DELETE
2100
2027
public.pofile                           = SELECT, UPDATE
2101
2028
public.pofiletranslator                 = SELECT, UPDATE
2102
2029
public.poll                             = SELECT, UPDATE
2103
 
public.posubscription                   = SELECT, UPDATE
2104
2030
public.potemplate                       = SELECT, UPDATE
2105
2031
public.product                          = SELECT, UPDATE
2106
2032
public.productrelease                   = SELECT, UPDATE
2107
2033
public.productreleasefile               = SELECT, UPDATE
2108
2034
public.productseries                    = SELECT, UPDATE
2109
2035
public.project                          = SELECT, UPDATE
2110
 
public.pushmirroraccess                 = SELECT, UPDATE
2111
2036
public.question                         = SELECT, UPDATE
2112
2037
public.questionjob                      = SELECT, UPDATE
2113
2038
public.questionreopening                = SELECT, UPDATE
2142
2067
public.usertouseremail                  = SELECT, UPDATE
2143
2068
public.vote                             = SELECT, UPDATE
2144
2069
public.votecast                         = SELECT, UPDATE
2145
 
public.webserviceban                    = SELECT, UPDATE, DELETE
2146
2070
public.wikiname                         = SELECT, UPDATE
2147
2071
type=user
2148
2072
 
2183
2107
public.job                              = SELECT, INSERT, DELETE
2184
2108
public.mailinglistsubscription          = SELECT, DELETE
2185
2109
public.oauthnonce                       = SELECT, DELETE
2186
 
public.openidassociation                = SELECT, DELETE
2187
2110
public.openidconsumerassociation        = SELECT, DELETE
2188
2111
public.openidconsumernonce              = SELECT, DELETE
2189
2112
public.person                           = SELECT, DELETE