Mercurial > gemma
diff schema/tap_tests_data.sql @ 343:5b03f420957d
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 |
line wrap: on
line diff
--- a/schema/tap_tests_data.sql Mon Aug 06 12:37:06 2018 +0200 +++ b/schema/tap_tests_data.sql Mon Aug 06 13:25:18 2018 +0200 @@ -8,13 +8,13 @@ ('AT', ST_geomfromtext('MULTIPOLYGON(((0 0, 0 1, 1 1, 1 0, 0 0)))', 4326)), ('RO', ST_geomfromtext('MULTIPOLYGON(((1 0, 1 1, 2 1, 2 0, 1 0)))', 4326)); -SELECT sys_admin.create_user( +INSERT INTO users.list_users VALUES ( 'waterway_user', 'test_user_at', 'user_at1$', 'AT', NULL, 'xxx'); -SELECT sys_admin.create_user( +INSERT INTO users.list_users VALUES ( 'waterway_user', 'test_user_ro', 'user_ro1$', 'RO', NULL, 'xxy'); -SELECT sys_admin.create_user( +INSERT INTO users.list_users VALUES ( 'waterway_admin', 'test_admin_at', 'admin_at1$', 'AT', NULL, 'yyy'); -SELECT sys_admin.create_user( +INSERT INTO users.list_users VALUES ( 'sys_admin', 'test_sys_admin1', 'sys_admin1$', 'AT', NULL, 'zzz'); CREATE ROLE test_pw_reset IN ROLE pw_reset LOGIN PASSWORD 'ppp';