Change Details

Due to {T157651} causing the drop of a table in production {T249565}, one of the action items is to remove `DROP` and `ALTER` grant from the `wikiadmin` user. This is what `wikiadmin` user currently have: ``` GRANT ALL PRIVILEGES ON `%wik%`.* ``` We should probably limit it to: - SELECT - UPDATE - INSERT - DELETE - PROCESS - REPLICATION CLIENT - CREATE - CREATE TEMPORARY TABLES - INDEX? Anything else?

Due to {T157651} causing the drop of a table in production {T249565}, one of the action items is to remove `DROP` and `ALTER` grant from the `wikiadmin` user. This is what `wikiadmin` user currently have: ``` GRANT ALL PRIVILEGES ON `%wik%`.* ``` We should probably limit it to: - SELECT - UPDATE - INSERT - DELETE - PROCESS - REPLICATION CLIENT - CREATE - CREATE TEMPORARY TABLES - INDEX? Anything else? (NOTE) https://wikitech.wikimedia.org/wiki/Incidents/2020-04-07_Wikidata%27s_wb_items_per_site_table_dropped

Due to {T157651} causing the drop of a table in production {T249565}, one of the action items is to remove `DROP` and `ALTER` grant from the `wikiadmin` user. This is what `wikiadmin` user currently have: ``` GRANT ALL PRIVILEGES ON `%wik%`.* ``` We should probably limit it to: - SELECT - UPDATE - INSERT - DELETE - PROCESS - REPLICATION CLIENT - CREATE - CREATE TEMPORARY TABLES - INDEX? Anything else? (NOTE) https://wikitech.wikimedia.org/wiki/Incidents/2020-04-07_Wikidata%27s_wb_items_per_site_table_dropped