  LANGUAGE plpgsql
 AS $function$
 BEGIN
-    EXECUTE format($$ CREATE USER %I IN ROLE :HUMAN_ROLE, admin $$, username);
+    EXECUTE format($$ CREATE USER %I IN ROLE zalandos, admin $$, username);
     EXECUTE format($$ ALTER ROLE %I SET log_statement TO 'all' $$, username);
 END;
 $function$
-SECURITY DEFINER;
+SECURITY DEFINER SET search_path to 'pg_catalog';
 
 REVOKE ALL ON FUNCTION create_user(text) FROM public;
 GRANT EXECUTE ON FUNCTION create_user(text) TO admin;

    END IF;
END
$function$
SECURITY DEFINER;

REVOKE ALL ON FUNCTION create_application_user_or_change_password(text, text) FROM public;
GRANT EXECUTE ON FUNCTION create_application_user_or_change_password(text, text) TO admin;

    RETURN pw;
END
$function$
SECURITY DEFINER SET search_path to 'pg_catalog';

REVOKE ALL ON FUNCTION create_application_user(text) FROM public;
GRANT EXECUTE ON FUNCTION create_application_user(text) TO admin;
