Mercurial > gemma
comparison schema/auth.sql @ 247:946baea3d280
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 |
comparison
equal
deleted
inserted
replaced
| 246:299568ad3c37 | 247:946baea3d280 |
|---|---|
| 25 -- Extended privileges for sys_admin | 25 -- Extended privileges for sys_admin |
| 26 -- | 26 -- |
| 27 GRANT INSERT, UPDATE, DELETE | 27 GRANT INSERT, UPDATE, DELETE |
| 28 ON users.responsibility_areas TO sys_admin; | 28 ON users.responsibility_areas TO sys_admin; |
| 29 GRANT USAGE ON SCHEMA sys_admin TO sys_admin; | 29 GRANT USAGE ON SCHEMA sys_admin TO sys_admin; |
| 30 GRANT SELECT ON ALL TABLES IN SCHEMA sys_admin TO sys_admin; | |
| 30 GRANT UPDATE ON sys_admin.system_config TO sys_admin; | 31 GRANT UPDATE ON sys_admin.system_config TO sys_admin; |
| 31 | 32 |
| 32 -- | 33 -- |
| 33 -- RLS policies for waterway_user | 34 -- RLS policies for waterway_user |
| 34 -- | 35 -- |