Mercurial > gemma
annotate schema/roles.sql @ 200:8426a92fda00
Persistent session store: Implmented Renew.
author | Sascha L. Teichmann <teichmann@intevation.de> |
---|---|
date | Sun, 22 Jul 2018 09:25:25 +0200 |
parents | a422471db08a |
children | 88d21c29cf04 |
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; |
a422471db08a
Automate running DB-tests with an extra database
Tom Gottfried <tom@intevation.de>
parents:
diff
changeset
|
6 CREATE ROLE sys_admin CREATEROLE BYPASSRLS IN ROLE waterway_admin; |