launchpad-reviewers team mailing list archive

[William Grant <me@xxxxxxxxxxxxxxxxxx>]

William Grant has proposed merging lp:~wgrant/launchpad/more-bug-heat-murder into lp:launchpad.

Requested reviews:
  Launchpad code reviewers (launchpad-reviewers)

For more details, see:
https://code.launchpad.net/~wgrant/launchpad/more-bug-heat-murder/+merge/96033

Remove four unused DB users, and drop grants for the dropped bugjob table.
-- 
https://code.launchpad.net/~wgrant/launchpad/more-bug-heat-murder/+merge/96033
Your team Launchpad code reviewers is requested to review the proposed merge of lp:~wgrant/launchpad/more-bug-heat-murder into lp:launchpad.

=== modified file 'database/schema/security.cfg'
--- database/schema/security.cfg	2012-03-05 03:49:22 +0000
+++ database/schema/security.cfg	2012-03-06 01:45:21 +0000
@@ -140,7 +140,6 @@
 public.bugattachment                    = SELECT, INSERT, UPDATE, DELETE
 public.bugbranch                        = SELECT, INSERT, UPDATE, DELETE
 public.bugcve                           = SELECT, INSERT, DELETE
-public.bugjob                           = SELECT, INSERT, UPDATE, DELETE
 public.bugnomination                    = SELECT, UPDATE
 public.bugnotification                  = SELECT, INSERT, UPDATE, DELETE
 public.bugnotificationattachment        = SELECT, INSERT
@@ -564,7 +563,6 @@
 public.bugactivity                      = SELECT, INSERT
 public.bugaffectsperson                 = SELECT, INSERT, UPDATE, DELETE
 public.bugcve                           = SELECT, INSERT
-public.bugjob                           = SELECT, INSERT
 public.bugmessage                       = SELECT, INSERT, UPDATE
 public.bugmute                          = SELECT
 public.bugnomination                    = SELECT
@@ -1124,7 +1122,6 @@
 public.bug                              = SELECT, INSERT, UPDATE
 public.bugactivity                      = SELECT, INSERT, UPDATE
 public.bugattachment                    = SELECT, INSERT, UPDATE
-public.bugjob                           = SELECT, INSERT
 public.bugmessage                       = SELECT, INSERT, UPDATE
 public.bugmute                          = SELECT, INSERT, UPDATE, DELETE
 public.bugnomination                    = SELECT, INSERT, UPDATE, DELETE
@@ -1273,7 +1270,6 @@
 public.bugactivity                      = SELECT, INSERT
 public.bugaffectsperson                 = SELECT, INSERT, UPDATE, DELETE
 public.bugcve                           = SELECT, INSERT
-public.bugjob                           = SELECT, INSERT
 public.bugmessage                       = SELECT, INSERT
 public.bugmute                          = SELECT
 public.bugnomination                    = SELECT
@@ -1377,7 +1373,6 @@
 public.bugactivity                      = SELECT, INSERT
 public.bugaffectsperson                 = SELECT, INSERT, UPDATE, DELETE
 public.bugcve                           = SELECT, INSERT
-public.bugjob                           = SELECT, INSERT
 public.bugmessage                       = SELECT, INSERT
 public.bugmute                          = SELECT
 public.bugnomination                    = SELECT
@@ -1470,13 +1465,6 @@
 type=user
 groups=queued
 
-[ppad]
-groups=script
-public.archive                          = SELECT
-public.archivearch                      = SELECT
-public.person                           = SELECT
-type=user
-
 [session]
 type=user
 
@@ -1490,7 +1478,6 @@
 public.bugactivity                      = SELECT, INSERT
 public.bugaffectsperson                 = SELECT, INSERT, UPDATE, DELETE
 public.bugattachment                    = SELECT
-public.bugjob                           = SELECT, INSERT
 public.bugmessage                       = SELECT, INSERT
 public.bugmute                          = SELECT
 public.bugnomination                    = SELECT
@@ -1641,15 +1628,6 @@
 public.translationtemplateitem          = SELECT
 type=user
 
-[oopsprune]
-groups=script
-public.bug                              = SELECT
-public.bugtask                          = SELECT
-public.message                          = SELECT
-public.messagechunk                     = SELECT
-public.question                         = SELECT
-type=user
-
 [listteammembers]
 public.emailaddress                     = SELECT
 public.person                           = SELECT
@@ -1680,7 +1658,6 @@
 public.bugattachment                    = SELECT, INSERT
 public.bugbranch                        = SELECT
 public.bugcve                           = SELECT, INSERT
-public.bugjob                           = SELECT, INSERT
 public.bugmessage                       = SELECT, INSERT
 public.bugmute                          = SELECT
 public.bugnomination                    = SELECT, INSERT, UPDATE
@@ -1942,7 +1919,6 @@
 public.account                          = SELECT, INSERT, UPDATE
 public.bug                              = SELECT, INSERT, UPDATE
 public.bugaffectsperson                 = SELECT, INSERT, UPDATE, DELETE
-public.bugjob                           = SELECT, INSERT
 public.bugmessage                       = SELECT, INSERT
 public.bugsubscription                  = SELECT, INSERT
 public.bugsubscriptionfilter            = SELECT, INSERT
@@ -2125,11 +2101,6 @@
 public.wikiname                         = SELECT, UPDATE
 type=user
 
-[weblogstats]
-public.libraryfilealias                 = SELECT
-public.libraryfiledownloadcount         = SELECT, INSERT, UPDATE, DELETE
-type=user
-
 [garbo]
 groups=script,read
 public.accesspolicy                     = SELECT, INSERT
@@ -2143,7 +2114,6 @@
 public.bug                              = SELECT, UPDATE
 public.bugaffectsperson                 = SELECT
 public.bugattachment                    = SELECT, DELETE
-public.bugjob                           = SELECT, INSERT
 public.bugmessage                       = SELECT, UPDATE
 public.bugnotification                  = SELECT, DELETE
 public.bugnotificationfilter            = SELECT, DELETE
@@ -2237,19 +2207,6 @@
 public.branch                           = SELECT
 type=user
 
-[calculate-bug-heat]
-groups=script,read
-public.bug                              = SELECT, UPDATE
-public.bugjob                           = SELECT, DELETE
-public.distribution                     = SELECT, UPDATE
-public.distributionsourcepackage        = SELECT, INSERT, UPDATE
-public.distroseries                     = SELECT
-public.job                              = SELECT, UPDATE, DELETE
-public.product                          = SELECT, UPDATE
-public.productseries                    = SELECT
-public.project                          = SELECT, UPDATE
-type=user
-
 [lagmon]
 public.update_replication_lag_cache()   = EXECUTE
 type=user