Mercurial > gemma
changeset 5385:7f5fc8ece589 extented-report
Forget to grant select rights to stats_updates table.
| author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
|---|---|
| date | Thu, 01 Jul 2021 22:19:38 +0200 |
| parents | 18969a4d31b6 |
| children | fc3a5345b0fd |
| files | schema/auth.sql schema/updates/1451/01.stats_updates.sql |
| diffstat | 2 files changed, 2 insertions(+), 2 deletions(-) [+] |
line wrap: on
line diff
--- 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
--- 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;