Jcrespo has submitted this change and it was merged.
Change subject: Adding wikiuser and wikiadmin grants to read the heartbeat table
......................................................................
Adding wikiuser and wikiadmin grants to read the heartbeat table
Change-Id: I4b4c93c07c5fe8595f9a966aa07dd2d6d62b49b5
References: T111266
---
M templates/mariadb/production-grants-core.sql.erb
1 file changed, 10 insertions(+), 0 deletions(-)
Approvals:
Jcrespo: Looks good to me, approved
Aaron Schulz: Looks good to me, but someone else must approve
jenkins-bot: Verified
diff --git a/templates/mariadb/production-grants-core.sql.erb
b/templates/mariadb/production-grants-core.sql.erb
index 0ec53fa..d74844a 100644
--- a/templates/mariadb/production-grants-core.sql.erb
+++ b/templates/mariadb/production-grants-core.sql.erb
@@ -10,6 +10,9 @@
GRANT ALL PRIVILEGES
ON `centralauth`.* TO 'wikiadmin'@'10.%';
+GRANT SELECT
+ ON `heartbeat`.`heartbeat` TO 'wikiadmin'@'10.%';
+
-- wikiuser 10.64.%
GRANT PROCESS, REPLICATION CLIENT
@@ -22,6 +25,9 @@
GRANT SELECT, INSERT, UPDATE, DELETE
ON `centralauth`.* TO 'wikiuser'@'10.64.%';
+GRANT SELECT
+ ON `heartbeat`.`heartbeat` TO 'wikiuser'@'10.64.%';
+
-- wikiuser 10.192.%
GRANT PROCESS, REPLICATION CLIENT
@@ -33,3 +39,7 @@
GRANT SELECT, INSERT, UPDATE, DELETE
ON `centralauth`.* TO 'wikiuser'@'10.192.%';
+
+GRANT SELECT
+ ON `heartbeat`.`heartbeat` TO 'wikiuser'@'10.192.%';
+
--
To view, visit https://gerrit.wikimedia.org/r/242211
To unsubscribe, visit https://gerrit.wikimedia.org/r/settings
Gerrit-MessageType: merged
Gerrit-Change-Id: I4b4c93c07c5fe8595f9a966aa07dd2d6d62b49b5
Gerrit-PatchSet: 2
Gerrit-Project: operations/puppet
Gerrit-Branch: production
Gerrit-Owner: Jcrespo <jcre...@wikimedia.org>
Gerrit-Reviewer: Aaron Schulz <asch...@wikimedia.org>
Gerrit-Reviewer: Jcrespo <jcre...@wikimedia.org>
Gerrit-Reviewer: jenkins-bot <>
_______________________________________________
MediaWiki-commits mailing list
MediaWiki-commits@lists.wikimedia.org
https://lists.wikimedia.org/mailman/listinfo/mediawiki-commits
