# HG changeset patch
# User Tom Gottfried <tom@intevation.de>
# Date 1532356821 -7200
# Node ID a0e2c6bb3cb30353c711943cf2e70e79c324ed27
# Parent  9585982180ab67ac43cb3f9f44be93c39eafcc41
Remove obsolete GRANT on user_profiles

Even sys_admin should write in this table only via
user management functions.

diff -r 9585982180ab -r a0e2c6bb3cb3 schema/auth.sql
--- a/schema/auth.sql	Mon Jul 23 16:14:36 2018 +0200
+++ b/schema/auth.sql	Mon Jul 23 16:40:21 2018 +0200
@@ -25,7 +25,7 @@
 -- Extended privileges for sys_admin
 --
 GRANT INSERT, UPDATE, DELETE
-    ON users.user_profiles, users.responsibility_areas TO sys_admin;
+    ON users.responsibility_areas TO sys_admin;
 GRANT USAGE ON SCHEMA sys_admin TO sys_admin;
 GRANT UPDATE ON sys_admin.system_config TO sys_admin;