Mercurial > gemma
changeset 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 | 9c2b796d506f |
| children | 3ad1c35b258f |
| files | auth.sql |
| diffstat | 1 files changed, 1 insertions(+), 1 deletions(-) [+] |
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;