launchpad-reviewers team mailing list archive

[Guruprasad <mp+444926@xxxxxxxxxxxxxxxxxx>]

Guruprasad has proposed merging ~lgp171188/launchpad:check-teamparticipation-teammembership-dbuser into launchpad:master.

Commit message:
Use the teammembership dbuser in the check-teamparticipation.py script

Requested reviews:
  Launchpad code reviewers (launchpad-reviewers)

For more details, see:
https://code.launchpad.net/~lgp171188/launchpad/+git/launchpad/+merge/444926
-- 
Your team Launchpad code reviewers is requested to review the proposed merge of ~lgp171188/launchpad:check-teamparticipation-teammembership-dbuser into launchpad:master.

diff --git a/cronscripts/check-teamparticipation.py b/cronscripts/check-teamparticipation.py
index 4aa205e..02ab955 100755
--- a/cronscripts/check-teamparticipation.py
+++ b/cronscripts/check-teamparticipation.py
@@ -68,4 +68,6 @@ class CheckTeamParticipationScript(LaunchpadCronScript):
 
 
 if __name__ == "__main__":
-    CheckTeamParticipationScript("check-teamparticipation").run()
+    CheckTeamParticipationScript(
+        "check-teamparticipation", dbuser="teammembership"
+    ).run()
diff --git a/database/schema/security.cfg b/database/schema/security.cfg
index 0c97ba9..4cb79a4 100644
--- a/database/schema/security.cfg
+++ b/database/schema/security.cfg
@@ -830,7 +830,7 @@ public.person                                 = SELECT
 public.persontransferjob                      = SELECT, INSERT
 public.sharingjob                             = SELECT, INSERT, UPDATE
 public.teammembership                         = SELECT, UPDATE
-public.teamparticipation                      = SELECT, DELETE
+public.teamparticipation                      = SELECT, INSERT, DELETE
 type=user
 
 [karma]