comparison schema/run_tests.sh @ 268:72062ca52746

Make user_profiles table invisible for users users.list_users should be the single point to access user profile data. Keeping user_profiles visible would imply having to maintain RLS policies that are otherwise obsolete. Tests run as superuser still use user_profiles, because list_users does not show any data to a superuser.
author Tom Gottfried <tom@intevation.de>
date Mon, 30 Jul 2018 11:38:09 +0200
parents 13ad969a9138
children 750a9c9cd965
comparison
equal deleted inserted replaced
267:7f030ec3472d 268:72062ca52746
13 13
14 # Drop test roles, add test data and run tests 14 # Drop test roles, add test data and run tests
15 psql -qXv ON_ERROR_STOP= -v -d gemma_test \ 15 psql -qXv ON_ERROR_STOP= -v -d gemma_test \
16 -c "DROP ROLE IF EXISTS $TEST_ROLES" \ 16 -c "DROP ROLE IF EXISTS $TEST_ROLES" \
17 -f tap_tests_data.sql \ 17 -f tap_tests_data.sql \
18 -c 'SELECT plan(42)' \ 18 -c 'SELECT plan(40)' \
19 -f auth_tests.sql \ 19 -f auth_tests.sql \
20 -f manage_users_tests.sql \ 20 -f manage_users_tests.sql \
21 -c 'SELECT * FROM finish()' 21 -c 'SELECT * FROM finish()'