log schema/auth.sql @ 1780:48791416bea5

age author description
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