# HG changeset patch # User Sascha L. Teichmann # Date 1625170778 -7200 # Node ID 7f5fc8ece589deb4d1e9bd5863b25dddc00296de # Parent 18969a4d31b688c5e0f56a6cb0603f7a77a53426 Forget to grant select rights to stats_updates table. diff -r 18969a4d31b6 -r 7f5fc8ece589 schema/auth.sql --- a/schema/auth.sql Thu Jul 01 21:56:50 2021 +0200 +++ b/schema/auth.sql Thu Jul 01 22:19:38 2021 +0200 @@ -62,7 +62,7 @@ GRANT UPDATE ON sys_admin.published_services TO sys_admin; GRANT INSERT, DELETE, UPDATE ON sys_admin.password_reset_requests TO sys_admin; GRANT DELETE ON import.imports, import.import_logs TO sys_admin; -GRANT INSERT, DELETE, UPDATE ON sys_admin.stats_updates TO sys_admin; +GRANT SELECT, INSERT, DELETE, UPDATE ON sys_admin.stats_updates TO sys_admin; -- -- Privileges assigned directly to metamorph diff -r 18969a4d31b6 -r 7f5fc8ece589 schema/updates/1451/01.stats_updates.sql --- a/schema/updates/1451/01.stats_updates.sql Thu Jul 01 21:56:50 2021 +0200 +++ b/schema/updates/1451/01.stats_updates.sql Thu Jul 01 22:19:38 2021 +0200 @@ -3,4 +3,4 @@ script TEXT NULL ); -GRANT INSERT, DELETE, UPDATE ON sys_admin.stats_updates TO sys_admin; +GRANT SELECT, INSERT, DELETE, UPDATE ON sys_admin.stats_updates TO sys_admin;