DB privilege error: poimport on TranslationMessage
Affects | Status | Importance | Assigned to | Milestone | |
---|---|---|---|---|---|
Launchpad itself |
Fix Released
|
Critical
|
Jeroen T. Vermeulen |
Bug Description
Just saw a permission-denied error from the translations importer, on TranslationMessage: http://
That may seem surprising, since the importer already has SELECT / INSERT / UPDATE on that table. But it makes sense. With translations message sharing, in rare cases, we may have to delete translation messages. We never thought to grant the DELETE privilege though, because it's so rarely needed and we don't normally delete data from this table.
When would we need to delete a TranslationMessage? When a current, diverged TM converges, but can't be updated because there's already an identical non-diverged message in the way. It may have happened before, but the appserver has all the privileges it needs.
Related branches
- Launchpad code reviewers: Pending requested
-
Diff: 12 lines (+1/-1)1 file modifieddatabase/schema/security.cfg (+1/-1)
- Launchpad code reviewers: Pending requested
-
Diff: 12 lines (+1/-1)1 file modifieddatabase/schema/security.cfg (+1/-1)
- William Grant: Approve (code)
-
Diff: 12 lines (+1/-1)1 file modifieddatabase/schema/security.cfg (+1/-1)
Changed in launchpad: | |
status: | Fix Committed → Fix Released |
Fixed in stable r14177 (http:// bazaar. launchpad. net/~launchpad- pqm/launchpad/ stable/ revision/ 14177) by a commit, but not testable.