launchpad-reviewers team mailing list archive

[Colin Watson <cjwatson@xxxxxxxxxxxxx>]

Colin Watson has proposed merging ~cjwatson/lp-signing:db-grants into lp-signing:master.

Commit message:
Grant the application access to database tables

Requested reviews:
  Launchpad code reviewers (launchpad-reviewers)

For more details, see:
https://code.launchpad.net/~cjwatson/lp-signing/+git/lp-signing/+merge/382581

Otherwise it can't do very much.
-- 
Your team Launchpad code reviewers is requested to review the proposed merge of ~cjwatson/lp-signing:db-grants into lp-signing:master.

diff --git a/migrations/patch-0-1-1-std.sql b/migrations/patch-0-1-1-std.sql
new file mode 100644
index 0000000..6d0b462
--- /dev/null
+++ b/migrations/patch-0-1-1-std.sql
@@ -0,0 +1,14 @@
+GRANT SELECT, INSERT, UPDATE, DELETE ON nonce TO "lp-signing";
+GRANT USAGE ON nonce_id_seq TO "lp-signing";
+
+GRANT SELECT, INSERT, UPDATE, DELETE ON client TO "lp-signing";
+GRANT USAGE ON client_id_seq TO "lp-signing";
+
+GRANT SELECT, INSERT, UPDATE, DELETE ON clientpublickey TO "lp-signing";
+GRANT USAGE ON clientpublickey_id_seq TO "lp-signing";
+
+GRANT SELECT, INSERT, UPDATE, DELETE ON key TO "lp-signing";
+GRANT USAGE ON key_id_seq TO "lp-signing";
+
+GRANT SELECT, INSERT, UPDATE, DELETE ON keyauthorization TO "lp-signing";
+GRANT USAGE ON keyauthorization_id_seq TO "lp-signing";