Mercurial > gemma
annotate schema/roles.sql @ 722:815f5e2ed974
Added simple endpoint to view system logs.
api/system/log/{service}/{file} allows to retrieve the raw log file
content for a selected set of services (currently "apache2" and
"postgresql").
The result is a JSON with two fields: "path:" contains the fully
qualified path of the retrieved log file in the servers file system
and "content:" provides the verbatim content of the requested log
file.
author | Sascha Wilde <wilde@intevation.de> |
---|---|
date | Fri, 21 Sep 2018 18:01:39 +0200 |
parents | 3af7ca761f6a |
children | 6590208e3ee1 |
rev | line source |
---|---|
172
a422471db08a
Automate running DB-tests with an extra database
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
1 -- |
a422471db08a
Automate running DB-tests with an extra database
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
2 -- Primary GEMMA roles |
a422471db08a
Automate running DB-tests with an extra database
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
3 -- |
a422471db08a
Automate running DB-tests with an extra database
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
4 CREATE ROLE waterway_user; |
a422471db08a
Automate running DB-tests with an extra database
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
5 CREATE ROLE waterway_admin IN ROLE waterway_user; |
207
88d21c29cf04
Care for the fact that role attributes are not inherited
Tom Gottfried <tom@intevation.de>
parents:
172
diff
changeset
|
6 CREATE ROLE sys_admin IN ROLE waterway_admin; |
319
ac760b0f22a9
Add special role for password reset
Tom Gottfried <tom@intevation.de>
parents:
207
diff
changeset
|
7 |
ac760b0f22a9
Add special role for password reset
Tom Gottfried <tom@intevation.de>
parents:
207
diff
changeset
|
8 -- |
ac760b0f22a9
Add special role for password reset
Tom Gottfried <tom@intevation.de>
parents:
207
diff
changeset
|
9 -- Special roles |
ac760b0f22a9
Add special role for password reset
Tom Gottfried <tom@intevation.de>
parents:
207
diff
changeset
|
10 -- |
ac760b0f22a9
Add special role for password reset
Tom Gottfried <tom@intevation.de>
parents:
207
diff
changeset
|
11 |
463
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
319
diff
changeset
|
12 -- A role that is intended to be used for backend- or |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
319
diff
changeset
|
13 -- GeoServer-connections on which SET ROLE has to be used to |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
319
diff
changeset
|
14 -- gain privileges of a specific role |
5611cf72cc92
Add metamorphic database role and user e.g. for GeoServer
Tom Gottfried <tom@intevation.de>
parents:
319
diff
changeset
|
15 CREATE ROLE metamorph NOINHERIT; |