Mercurial > gemma
view schema/std_login_roles.sql @ 521:139214cecc8f
backend: add FIXMEs to password reset.
* Add FIXMEs to write down knowledge about how the password request
probably has to be improved.
author | Bernhard Reiter <bernhard@intevation.de> |
---|---|
date | Mon, 27 Aug 2018 17:09:51 +0200 |
parents | 3af7ca761f6a |
children | 67c3837bcc3d |
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 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;