Mercurial > gemma

diff schema/manage_users_tests.sql @ 224:57dfab80973c

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
By convention, prefix all test users with 'test' This allows to DROP them without having to fixup run_tests.sh always after adding a new test user. Further fixup of rev. cfde876fbaf9: Remove obsolete comment.
author Tom Gottfried <tom@intevation.de>
date Wed, 25 Jul 2018 13:34:46 +0200
parents 88d21c29cf04
children 8b9cae6d3a21
line wrap: on
line diff
--- a/schema/manage_users_tests.sql	Wed Jul 25 12:37:03 2018 +0200
+++ b/schema/manage_users_tests.sql	Wed Jul 25 13:34:46 2018 +0200
@@ -4,7 +4,7 @@
 
 SET search_path TO public, gemma, gemma_waterway, gemma_fairway;
 
-SET SESSION AUTHORIZATION admin_at;
+SET SESSION AUTHORIZATION test_admin_at;
 
 SELECT throws_ok($$
     SELECT sys_admin.create_user(
@@ -13,7 +13,7 @@
     42501, NULL,
     'Less privileged user cannot call function in schema sys_admin');
 
-SET SESSION AUTHORIZATION sys_admin1;
+SET SESSION AUTHORIZATION test_sys_admin1;
 
 SELECT lives_ok($$
     SELECT sys_admin.create_user(
@@ -45,7 +45,7 @@
 
 SELECT throws_ok($$
     SELECT sys_admin.create_user(
-        'waterway_user', 'user_at', 'secret', 'AT', NULL, 'test4')
+        'waterway_user', 'test_user_at', 'secret', 'AT', NULL, 'test4')
     $$,
     23505, NULL,
     'No duplicate user name is allowed');