Launchpad itself

Merge lp:~wgrant/launchpad/more-bug-heat-murder into lp:launchpad

  1. more-bug-heat-murder
  2. Merge into devel
Proposed by William Grant on 2012-03-06
Status: Merged
Approved by: William Grant on 2012-03-07
Approved revision: no longer in the source branch.
Merged at revision: 14917
Proposed branch: lp:~wgrant/launchpad/more-bug-heat-murder
Merge into: lp:launchpad
Diff against target: 137 lines (+0/-43)
1 file modified
database/schema/security.cfg (+0/-43)
To merge this branch: bzr merge lp:~wgrant/launchpad/more-bug-heat-murder
Reviewer Review Type Date Requested Status
Robert Collins (community) 2012-03-06 Approve on 2012-03-06
Review via email: mp+96033@code.launchpad.net

Commit Message

Remove four unused DB users, and drop grants for the dropped bugjob table.

Description of the Change

Remove four unused DB users, and drop grants for the dropped bugjob table.

To post a comment you must log in.
Robert Collins (lifeless) wrote :

+1

review: Approve

Preview Diff

[H/L] Next/Prev Comment, [J/K] Next/Prev File, [N/P] Next/Prev Hunk
1=== modified file 'database/schema/security.cfg'
2--- database/schema/security.cfg 2012-03-06 05:23:43 +0000
3+++ database/schema/security.cfg 2012-03-07 22:32:20 +0000
4@@ -140,7 +140,6 @@
5 public.bugattachment = SELECT, INSERT, UPDATE, DELETE
6 public.bugbranch = SELECT, INSERT, UPDATE, DELETE
7 public.bugcve = SELECT, INSERT, DELETE
8-public.bugjob = SELECT, INSERT, UPDATE, DELETE
9 public.bugnomination = SELECT, UPDATE
10 public.bugnotification = SELECT, INSERT, UPDATE, DELETE
11 public.bugnotificationattachment = SELECT, INSERT
12@@ -564,7 +563,6 @@
13 public.bugactivity = SELECT, INSERT
14 public.bugaffectsperson = SELECT, INSERT, UPDATE, DELETE
15 public.bugcve = SELECT, INSERT
16-public.bugjob = SELECT, INSERT
17 public.bugmessage = SELECT, INSERT, UPDATE
18 public.bugmute = SELECT
19 public.bugnomination = SELECT
20@@ -1124,7 +1122,6 @@
21 public.bug = SELECT, INSERT, UPDATE
22 public.bugactivity = SELECT, INSERT, UPDATE
23 public.bugattachment = SELECT, INSERT, UPDATE
24-public.bugjob = SELECT, INSERT
25 public.bugmessage = SELECT, INSERT, UPDATE
26 public.bugmute = SELECT, INSERT, UPDATE, DELETE
27 public.bugnomination = SELECT, INSERT, UPDATE, DELETE
28@@ -1273,7 +1270,6 @@
29 public.bugactivity = SELECT, INSERT
30 public.bugaffectsperson = SELECT, INSERT, UPDATE, DELETE
31 public.bugcve = SELECT, INSERT
32-public.bugjob = SELECT, INSERT
33 public.bugmessage = SELECT, INSERT
34 public.bugmute = SELECT
35 public.bugnomination = SELECT
36@@ -1377,7 +1373,6 @@
37 public.bugactivity = SELECT, INSERT
38 public.bugaffectsperson = SELECT, INSERT, UPDATE, DELETE
39 public.bugcve = SELECT, INSERT
40-public.bugjob = SELECT, INSERT
41 public.bugmessage = SELECT, INSERT
42 public.bugmute = SELECT
43 public.bugnomination = SELECT
44@@ -1470,13 +1465,6 @@
45 type=user
46 groups=queued
47
48-[ppad]
49-groups=script
50-public.archive = SELECT
51-public.archivearch = SELECT
52-public.person = SELECT
53-type=user
54-
55 [session]
56 type=user
57
58@@ -1490,7 +1478,6 @@
59 public.bugactivity = SELECT, INSERT
60 public.bugaffectsperson = SELECT, INSERT, UPDATE, DELETE
61 public.bugattachment = SELECT
62-public.bugjob = SELECT, INSERT
63 public.bugmessage = SELECT, INSERT
64 public.bugmute = SELECT
65 public.bugnomination = SELECT
66@@ -1641,15 +1628,6 @@
67 public.translationtemplateitem = SELECT
68 type=user
69
70-[oopsprune]
71-groups=script
72-public.bug = SELECT
73-public.bugtask = SELECT
74-public.message = SELECT
75-public.messagechunk = SELECT
76-public.question = SELECT
77-type=user
78-
79 [listteammembers]
80 public.emailaddress = SELECT
81 public.person = SELECT
82@@ -1680,7 +1658,6 @@
83 public.bugattachment = SELECT, INSERT
84 public.bugbranch = SELECT
85 public.bugcve = SELECT, INSERT
86-public.bugjob = SELECT, INSERT
87 public.bugmessage = SELECT, INSERT
88 public.bugmute = SELECT
89 public.bugnomination = SELECT, INSERT, UPDATE
90@@ -1942,7 +1919,6 @@
91 public.account = SELECT, INSERT, UPDATE
92 public.bug = SELECT, INSERT, UPDATE
93 public.bugaffectsperson = SELECT, INSERT, UPDATE, DELETE
94-public.bugjob = SELECT, INSERT
95 public.bugmessage = SELECT, INSERT
96 public.bugsubscription = SELECT, INSERT
97 public.bugsubscriptionfilter = SELECT, INSERT
98@@ -2125,11 +2101,6 @@
99 public.wikiname = SELECT, UPDATE
100 type=user
101
102-[weblogstats]
103-public.libraryfilealias = SELECT
104-public.libraryfiledownloadcount = SELECT, INSERT, UPDATE, DELETE
105-type=user
106-
107 [garbo]
108 groups=script,read
109 public.account = SELECT, DELETE
110@@ -2142,7 +2113,6 @@
111 public.bug = SELECT, UPDATE
112 public.bugaffectsperson = SELECT
113 public.bugattachment = SELECT, DELETE
114-public.bugjob = SELECT, INSERT
115 public.bugmessage = SELECT, UPDATE
116 public.bugnotification = SELECT, DELETE
117 public.bugnotificationfilter = SELECT, DELETE
118@@ -2236,19 +2206,6 @@
119 public.branch = SELECT
120 type=user
121
122-[calculate-bug-heat]
123-groups=script,read
124-public.bug = SELECT, UPDATE
125-public.bugjob = SELECT, DELETE
126-public.distribution = SELECT, UPDATE
127-public.distributionsourcepackage = SELECT, INSERT, UPDATE
128-public.distroseries = SELECT
129-public.job = SELECT, UPDATE, DELETE
130-public.product = SELECT, UPDATE
131-public.productseries = SELECT
132-public.project = SELECT, UPDATE
133-type=user
134-
135 [lagmon]
136 public.update_replication_lag_cache() = EXECUTE
137 type=user