Mercurial > gemma
changeset 210:a0e2c6bb3cb3
Remove obsolete GRANT on user_profiles
Even sys_admin should write in this table only via
user management functions.
| author | Tom Gottfried <tom@intevation.de> |
|---|---|
| date | Mon, 23 Jul 2018 16:40:21 +0200 |
| parents | 9585982180ab |
| children | e7826710d9c4 |
| files | schema/auth.sql |
| diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
line wrap: on
line diff
--- 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;