Mercurial > gemma
diff schema/demo-data/users.sql @ 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 | 531d1f8a2b4b |
| children | 46a80016293c |
line wrap: on
line diff
--- a/schema/demo-data/users.sql Mon Jul 30 11:08:17 2018 +0200 +++ b/schema/demo-data/users.sql Mon Jul 30 11:38:09 2018 +0200 @@ -5,7 +5,7 @@ -- responsibility areas from responsibility_areas.sql are imported -- Fill in Profiles -COPY users.user_profiles (username, country, email_address, map_extent) FROM stdin; +COPY internal.user_profiles (username, country, email_address, map_extent) FROM stdin; sophie AT sophie@example.com BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001) lucian RO lucian@example.com BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001) oana RO oana@example.com BOX(20.2428259690001 43.6500499480001,29.6995548840001 48.2748322560001)