Mercurial > gemma

diff schema/auth.sql @ 247:946baea3d280

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Add view to list user profiles with role To be able to GRANT privileges ON ALL TABLES IN SCHEMA, use auth.sql last during database setup.
author Tom Gottfried <tom@intevation.de>
date Thu, 26 Jul 2018 19:33:42 +0200
parents a0e2c6bb3cb3
children 13ad969a9138
line wrap: on
line diff
--- a/schema/auth.sql	Thu Jul 26 19:22:07 2018 +0200
+++ b/schema/auth.sql	Thu Jul 26 19:33:42 2018 +0200
@@ -27,6 +27,7 @@
 GRANT INSERT, UPDATE, DELETE
     ON users.responsibility_areas TO sys_admin;
 GRANT USAGE ON SCHEMA sys_admin TO sys_admin;
+GRANT SELECT ON ALL TABLES IN SCHEMA sys_admin TO sys_admin;
 GRANT UPDATE ON sys_admin.system_config TO sys_admin;
 
 --