Mercurial > gemma
diff auth.sql @ 98:81a2b26bf16b
SELECT privilege on a table is useless without USAGE on the schema.
author | Tom Gottfried <tom@intevation.de> |
---|---|
date | Wed, 13 Jun 2018 22:39:38 +0200 |
parents | d036e1bd5f00 |
children | b29538ac409d |
line wrap: on
line diff
--- a/auth.sql Fri Jun 08 12:43:57 2018 +0200 +++ b/auth.sql Wed Jun 13 22:39:38 2018 +0200 @@ -18,7 +18,7 @@ -- -- Privileges for waterway_user -- -GRANT USAGE ON SCHEMA wamos_waterway, wamos_fairway TO waterway_user; +GRANT USAGE ON SCHEMA wamos, wamos_waterway, wamos_fairway TO waterway_user; GRANT SELECT ON ALL TABLES IN SCHEMA wamos_waterway, wamos_fairway TO waterway_user; GRANT SELECT ON templates, user_profiles TO waterway_user;