Mercurial > gemma

comparison schema/tap_tests_data.sql @ 343:5b03f420957d

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Use INSTEAD OF trigger for user creation Now make the whole thing look like a real table. There is no more function in schema sys_admin, thus remove respective privilege test.
author Tom Gottfried <tom@intevation.de>
date Mon, 06 Aug 2018 13:25:18 +0200
parents ac760b0f22a9
children 3af7ca761f6a
comparison
equal deleted inserted replaced
342:c6bd6ed18942 343:5b03f420957d
6 6
7 INSERT INTO users.responsibility_areas VALUES 7 INSERT INTO users.responsibility_areas VALUES
8 ('AT', ST_geomfromtext('MULTIPOLYGON(((0 0, 0 1, 1 1, 1 0, 0 0)))', 4326)), 8 ('AT', ST_geomfromtext('MULTIPOLYGON(((0 0, 0 1, 1 1, 1 0, 0 0)))', 4326)),
9 ('RO', ST_geomfromtext('MULTIPOLYGON(((1 0, 1 1, 2 1, 2 0, 1 0)))', 4326)); 9 ('RO', ST_geomfromtext('MULTIPOLYGON(((1 0, 1 1, 2 1, 2 0, 1 0)))', 4326));
10 10
11 SELECT sys_admin.create_user( 11 INSERT INTO users.list_users VALUES (
12 'waterway_user', 'test_user_at', 'user_at1$', 'AT', NULL, 'xxx'); 12 'waterway_user', 'test_user_at', 'user_at1$', 'AT', NULL, 'xxx');
13 SELECT sys_admin.create_user( 13 INSERT INTO users.list_users VALUES (
14 'waterway_user', 'test_user_ro', 'user_ro1$', 'RO', NULL, 'xxy'); 14 'waterway_user', 'test_user_ro', 'user_ro1$', 'RO', NULL, 'xxy');
15 SELECT sys_admin.create_user( 15 INSERT INTO users.list_users VALUES (
16 'waterway_admin', 'test_admin_at', 'admin_at1$', 'AT', NULL, 'yyy'); 16 'waterway_admin', 'test_admin_at', 'admin_at1$', 'AT', NULL, 'yyy');
17 SELECT sys_admin.create_user( 17 INSERT INTO users.list_users VALUES (
18 'sys_admin', 'test_sys_admin1', 'sys_admin1$', 'AT', NULL, 'zzz'); 18 'sys_admin', 'test_sys_admin1', 'sys_admin1$', 'AT', NULL, 'zzz');
19 19
20 CREATE ROLE test_pw_reset IN ROLE pw_reset LOGIN PASSWORD 'ppp'; 20 CREATE ROLE test_pw_reset IN ROLE pw_reset LOGIN PASSWORD 'ppp';
21 21
22 INSERT INTO limiting_factors VALUES ('depth'), ('width'); 22 INSERT INTO limiting_factors VALUES ('depth'), ('width');