Mercurial > gemma
comparison schema/updates/1402/01.group_layers.sql @ 4933:45ef039cf4a8 fairway-marks-import
grant select rights to sys_admin to new group layers tables.
author | Sascha L. Teichmann <sascha.teichmann@intevation.de> |
---|---|
date | Sat, 15 Feb 2020 19:08:02 +0100 |
parents | 8b83b18a1d49 |
children |
comparison
equal
deleted
inserted
replaced
4932:2b46e7c51511 | 4933:45ef039cf4a8 |
---|---|
10 PRIMARY KEY (group_name, schema, name), | 10 PRIMARY KEY (group_name, schema, name), |
11 UNIQUE (group_name, schema, name, ord), | 11 UNIQUE (group_name, schema, name, ord), |
12 FOREIGN KEY(schema, name) REFERENCES sys_admin.published_services | 12 FOREIGN KEY(schema, name) REFERENCES sys_admin.published_services |
13 ); | 13 ); |
14 | 14 |
15 GRANT SELECT ON sys_admin.layer_groups, sys_admin.grouped_layers TO sys_admin; |