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.
|
Mon, 24 Sep 2018 11:36:30 +0200 |
Sascha L. Teichmann |
Granted rights to sys_admin on waterway.sounding_results_contour_lines.
|
Thu, 23 Aug 2018 16:41:44 +0200 |
Tom Gottfried |
Purge password reset role
|
Wed, 22 Aug 2018 16:48:56 +0200 |
Tom Gottfried |
Add metamorphic database role and user e.g. for GeoServer
|
Thu, 09 Aug 2018 15:45:16 +0200 |
Tom Gottfried |
Store spatial data as geography
|
Mon, 06 Aug 2018 15:19:05 +0200 |
Tom Gottfried |
Add staging feature to more tables
|
Thu, 02 Aug 2018 19:25:30 +0200 |
Tom Gottfried |
Allow Waterway User to update a limited set of profile attributes
|
Thu, 02 Aug 2018 15:14:38 +0200 |
Sascha L. Teichmann |
Added new table password_reset_requests to schema pw_reset.
|
Thu, 02 Aug 2018 13:06:39 +0200 |
Tom Gottfried |
Add special role for password reset
|
Wed, 01 Aug 2018 18:16:14 +0200 |
Tom Gottfried |
Lock out the PUBLIC more rigorously
|
Wed, 01 Aug 2018 17:35:12 +0200 |
Tom Gottfried |
Place functions in more matching schemas
|
Wed, 01 Aug 2018 15:49:38 +0200 |
Tom Gottfried |
Use SQL UPDATE to update users
|
Mon, 30 Jul 2018 11:38:09 +0200 |
Tom Gottfried |
Make user_profiles table invisible for users
|
Fri, 27 Jul 2018 19:03:56 +0200 |
Tom Gottfried |
Enable listing of users for all roles with appropriate filters
|
Thu, 26 Jul 2018 19:33:42 +0200 |
Tom Gottfried |
Add view to list user profiles with role
|
Mon, 23 Jul 2018 16:40:21 +0200 |
Tom Gottfried |
Remove obsolete GRANT on user_profiles
|
Fri, 20 Jul 2018 17:28:16 +0200 |
Tom Gottfried |
Introduce database schemas as privilege-based namespaces
|
Wed, 18 Jul 2018 16:48:27 +0200 |
Tom Gottfried |
Beautify SQL
|
Tue, 17 Jul 2018 19:08:18 +0200 |
Tom Gottfried |
Improve RLS policies for template data
|
Tue, 17 Jul 2018 18:21:56 +0200 |
Tom Gottfried |
Add missing privilege for waterway_admin
|
Tue, 17 Jul 2018 16:50:16 +0200 |
Tom Gottfried |
Make schema for templates more realistic
|
Fri, 13 Jul 2018 14:56:32 +0200 |
Tom Gottfried |
Allow waterway_admin to see profiles of users in same country
|
Thu, 12 Jul 2018 16:30:01 +0200 |
Tom Gottfried |
Automate running DB-tests with an extra database
|
Tue, 26 Jun 2018 16:20:04 +0200 |
Sascha L. Teichmann |
s/wamos/gemma/g on database schema.
|
Tue, 26 Jun 2018 16:14:59 +0200 |
Sascha L. Teichmann |
Moved schema stuff to own subfolder.
base
auth.sql@63cafb14177c
|