Mercurial > gemma
view schema/std_login_roles.sql @ 628:ef9c733cc6aa
client: show more wfs layers
* Add waterway axis, waterway area and distance marks as fully loaded
WFS layers. Distance marks are disabled by default, with code
that honors the isVisible attribute. Code is duplicated, and marked
with FIXMEs.
author | Bernhard Reiter <bernhard@intevation.de> |
---|---|
date | Tue, 11 Sep 2018 17:52:20 +0200 |
parents | 67c3837bcc3d |
children | 6590208e3ee1 |
line wrap: on
line source
BEGIN; -- -- Standard users for the GEMMA database -- -- NOTE: Passwords for these roles must be set during initial setup of -- the database. -- -- Admin User -- -- This initial Admin account is used to bootstrap the personalized -- accounts. CREATE ROLE sysadmin IN ROLE sys_admin ROLE metamorph LOGIN PASSWORD :'adminpw'; -- We need an empty dummy country for the default admin, as the user is -- not supposed to work on data, it should be only used to create -- personalized accounts. INSERT INTO countries (country_code) VALUES ('--'); INSERT INTO users.responsibility_areas (country, area) VALUES ('--', ST_GeomFromText('MULTIPOLYGON(((0 0, 0 0, 0 0, 0 0)))', 4326)); -- Add user profile data for sysadmin INSERT INTO internal.user_profiles (username, country, email_address, map_extent) VALUES ('sysadmin','--','', 'BOX(9.52115482500011 46.3786430870001,17.1483378500001 49.0097744750001)'); -- -- Functional Users -- -- Used by GeoServer and backend CREATE ROLE meta_login IN ROLE metamorph LOGIN PASSWORD :'metapw'; -- Emit messages to the client if everything went ok SELECT 'Default admin user ''sysadmin'' created with password ' || :'adminpw'; SELECT 'Backend user ''meta_login'' created with password ' || :'metapw'; COMMIT;