Mercurial > gemma
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()' |