log schema/auth.sql @ 5682:33499bd1b829 sr-v2

age author description
Wed, 22 Sep 2021 18:50:16 +0200 Sascha L. Teichmann Removed delete_user plpgsql function. deactivate-users
Tue, 21 Sep 2021 22:06:43 +0200 Sascha L. Teichmann Moved logic to delete deactivate users into plpgsql function. deactivate-users
Thu, 01 Jul 2021 22:19:38 +0200 Sascha L. Teichmann Forget to grant select rights to stats_updates table. extented-report
Thu, 01 Jul 2021 21:56:50 +0200 Sascha L. Teichmann Added a table to store SQL update scripts for aggregated data. extented-report
Wed, 25 Mar 2020 16:51:45 +0100 Sascha L. Teichmann Enable jobs to be removed by the import queue. queued-stage-done
Wed, 18 Mar 2020 12:16:42 +0100 Tom Gottfried Fix row level security policies for waterway admin
Fri, 13 Mar 2020 17:34:59 +0100 Tom Gottfried Keep historic data of waterway axis
Fri, 13 Mar 2020 14:09:32 +0100 Tom Gottfried Inline SQL function in row level security policies
Thu, 12 Mar 2020 14:49:19 +0100 Tom Gottfried Add row level security policies for waterway axis
Wed, 13 Nov 2019 10:52:50 +0100 Tom Gottfried Remove obsolete comment
Wed, 23 Oct 2019 16:41:43 +0200 Sascha Wilde Added epic comments on responsibility_area and same_country policies.
Wed, 23 Oct 2019 15:23:52 +0200 Sascha Wilde Improved performance for RLS on read access.
Fri, 18 Oct 2019 12:04:04 +0200 Tom Gottfried Authorize sections based on country of creator
Tue, 15 Oct 2019 16:28:46 +0200 Tom Gottfried Add missing RLS policies for sections
Thu, 12 Sep 2019 18:13:47 +0200 Sascha Wilde Use stretches as areas of responsibility. stretches-for-responsibility
Wed, 21 Aug 2019 16:17:46 +0200 Bernhard Reiter Remove unused systemconf.feature_colours from backend
Fri, 02 Aug 2019 17:14:13 +0200 Tom Gottfried Improve performance of row level security policies
Fri, 02 Aug 2019 16:10:42 +0200 Tom Gottfried Remove utility function with possibly bad performance impact
Tue, 16 Jul 2019 12:38:44 +0200 Sascha L. Teichmann Reworked password reset to be single mailed. pwreset-rework
Sat, 15 Jun 2019 14:36:50 +0200 Tom Gottfried Align bottleneck validity at gauges
Tue, 11 Jun 2019 12:43:05 +0200 Sascha L. Teichmann Added missing insert grant to sys_admin.system_config for sys_admins. configuration
Fri, 07 Jun 2019 14:17:01 +0200 Markus Kottlaender grant read permission on system_config for waterway_users configuration
Thu, 16 May 2019 18:41:43 +0200 Tom Gottfried 'Historicise' gauges on import
Wed, 03 Apr 2019 16:42:03 +0200 Tom Gottfried Allow sys_admin to access tables in staging area without restrictions
Wed, 03 Apr 2019 15:26:39 +0200 Tom Gottfried Simplify function and move to appropriate schema
Wed, 27 Mar 2019 10:52:09 +0100 Sascha L. Teichmann Due to performance problems with users.current_user_country() inlined it as
Thu, 07 Mar 2019 15:55:25 +0100 Sascha L. Teichmann Schema: Added caching schema containing the sounding differences.
Thu, 14 Feb 2019 15:11:00 +0100 Sascha L. Teichmann Ajjusted RLS for user templates.
Wed, 13 Feb 2019 16:59:38 +0100 Sascha Wilde sysadmin users shall be able to create new stretches w/o restrictions.
Wed, 13 Feb 2019 10:52:14 +0100 Tom Gottfried Remove debris and associate templates to country
Fri, 08 Feb 2019 11:02:05 +0100 Sascha L. Teichmann Print templates: Stubbed endpoints under /api/templates/print/{name}
Wed, 30 Jan 2019 23:57:51 +0100 Sascha L. Teichmann Waterway profiles import: Implemented the parsing of the data lines of the CSV file and stored the values into the database.
Thu, 24 Jan 2019 12:56:31 +0100 Tom Gottfried Move import queue to its own database namespace
Wed, 23 Jan 2019 16:25:43 +0100 Tom Gottfried Fix area generation from multipolygon input
Fri, 18 Jan 2019 18:15:41 +0100 Sascha L. Teichmann Fixed RLS policy for waterway.stretches.
Fri, 18 Jan 2019 12:11:50 +0100 Sascha L. Teichmann Fixed RLS for stretches table.
Thu, 17 Jan 2019 19:22:49 +0100 Tom Gottfried Fix policies interfering badly with integrity checks
Thu, 17 Jan 2019 18:15:15 +0100 Tom Gottfried Simplify RLS policies on import jobs
Thu, 17 Jan 2019 09:27:28 +0100 Raimund Renkert Added RLS for responsibility area on fairway dimensions.
Wed, 16 Jan 2019 18:12:41 +0100 Tom Gottfried Sync access to import config attributes to import config
Wed, 16 Jan 2019 17:30:13 +0100 Tom Gottfried Move not only authentication related functions to own file
Mon, 14 Jan 2019 17:43:28 +0100 Tom Gottfried Row level security for import jobs
Fri, 11 Jan 2019 17:43:26 +0100 Sascha L. Teichmann RLS gauge_measurements: Another attempt.
Fri, 11 Jan 2019 16:48:14 +0100 Sascha L. Teichmann (Approved) gauge measurement import: Fixed row level security.
Wed, 09 Jan 2019 15:53:48 +0100 Sascha L. Teichmann Configured imports: Allow sys_admin access to import_configuation.
Thu, 20 Dec 2018 12:05:30 +0100 Raimund Renkert Updated database schema for gauge meaurement imports.
Wed, 19 Dec 2018 18:12:03 +0100 Tom Gottfried Cleanup GRANTs for waterway_admin
Wed, 19 Dec 2018 16:48:00 +0100 Sascha L. Teichmann Added grants to waterway.bottlenecks to waterway.admin to pass declining of imports.
Mon, 10 Dec 2018 15:55:10 +0100 Sascha L. Teichmann Add table to store import configuration.
Mon, 26 Nov 2018 15:21:34 +0100 Sascha L. Teichmann Added missing rights and fixed trigger function.
Sat, 24 Nov 2018 16:22:28 +0100 Sascha L. Teichmann Added missing copyright headers and authors in schema related files.
Fri, 23 Nov 2018 10:35:39 +0100 Fadi Abbud add headers for licensing to some schema files
Fri, 23 Nov 2018 09:35:10 +0100 Fadi Abbud add headers for licensing to some schema files
Tue, 20 Nov 2018 00:51:33 +0100 Sascha L. Teichmann Improved performance of row level security check on users responsibility areas
Wed, 14 Nov 2018 12:23:10 +0100 Sascha L. Teichmann Track successfull imports in a separate table to be able to remove them later.
Wed, 07 Nov 2018 18:08:57 +0100 Tom Gottfried Remove obsolete GRANT to sys_admin
Wed, 24 Oct 2018 16:21:44 +0200 Sascha L. Teichmann Added endpoint to delete job from import queue.
Sun, 30 Sep 2018 11:49:23 +0200 Sascha L. Teichmann More on uploading styles to gemma. geo-style
Fri, 28 Sep 2018 11:51:06 +0200 Sascha Wilde Added end point to set style (colour) information for feature.
Fri, 28 Sep 2018 10:56:03 +0200 Sascha Wilde Added end point to get style (colour) information for feature.