Mercurial > gemma
comparison schema/auth.sql @ 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 | a30b6c6541e0 |
comparison
equal
deleted
inserted
replaced
| 5384:18969a4d31b6 | 5385:7f5fc8ece589 |
|---|---|
| 60 GRANT SELECT ON ALL TABLES IN SCHEMA sys_admin TO sys_admin; | 60 GRANT SELECT ON ALL TABLES IN SCHEMA sys_admin TO sys_admin; |
| 61 GRANT INSERT, UPDATE ON sys_admin.system_config TO sys_admin; | 61 GRANT INSERT, UPDATE ON sys_admin.system_config TO sys_admin; |
| 62 GRANT UPDATE ON sys_admin.published_services TO sys_admin; | 62 GRANT UPDATE ON sys_admin.published_services TO sys_admin; |
| 63 GRANT INSERT, DELETE, UPDATE ON sys_admin.password_reset_requests TO sys_admin; | 63 GRANT INSERT, DELETE, UPDATE ON sys_admin.password_reset_requests TO sys_admin; |
| 64 GRANT DELETE ON import.imports, import.import_logs TO sys_admin; | 64 GRANT DELETE ON import.imports, import.import_logs TO sys_admin; |
| 65 GRANT INSERT, DELETE, UPDATE ON sys_admin.stats_updates TO sys_admin; | 65 GRANT SELECT, INSERT, DELETE, UPDATE ON sys_admin.stats_updates TO sys_admin; |
| 66 | 66 |
| 67 -- | 67 -- |
| 68 -- Privileges assigned directly to metamorph | 68 -- Privileges assigned directly to metamorph |
| 69 -- | 69 -- |
| 70 -- Needed for GeoServer's system inspection run before session startup SQL | 70 -- Needed for GeoServer's system inspection run before session startup SQL |