log schema/manage_users.sql @ 5402:f5063fa7f666 marking-single-beam

age author description
Fri, 13 Mar 2020 14:09:32 +0100 Tom Gottfried Inline SQL function in row level security policies
Fri, 18 Oct 2019 12:04:04 +0200 Tom Gottfried Authorize sections based on country of creator
Thu, 17 Oct 2019 18:56:59 +0200 Tom Gottfried Avoid creating user profiles without matching role
Thu, 12 Sep 2019 18:13:47 +0200 Sascha Wilde Use stretches as areas of responsibility. stretches-for-responsibility
Fri, 02 Aug 2019 16:10:42 +0200 Tom Gottfried Remove utility function with possibly bad performance impact
Wed, 03 Apr 2019 15:26:39 +0200 Tom Gottfried Simplify function and move to appropriate schema
Tue, 02 Apr 2019 19:25:17 +0200 Tom Gottfried Add utility function to get users area of responsibility
Mon, 26 Nov 2018 09:01:21 +0100 Fadi Abbud merges
Fri, 23 Nov 2018 13:46:47 +0100 Fadi Abbud add headers for licensing to some schema files
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
Thu, 23 Aug 2018 16:41:44 +0200 Tom Gottfried Purge password reset role
Wed, 22 Aug 2018 17:56:16 +0200 Sascha L. Teichmann Don't use hex encoding for user impersonation when running it from a planned statement.
Wed, 22 Aug 2018 17:43:30 +0200 Sascha L. Teichmann Used hex-encoded usernames and a stored procedure to decode them to impersonate with the metamorph user.
Wed, 22 Aug 2018 16:48:56 +0200 Tom Gottfried Add metamorphic database role and user e.g. for GeoServer
Wed, 15 Aug 2018 16:39:00 +0200 Tom Gottfried Do not rely on session_user for authorization
Thu, 09 Aug 2018 15:45:16 +0200 Tom Gottfried Store spatial data as geography
Mon, 06 Aug 2018 13:25:18 +0200 Tom Gottfried Use INSTEAD OF trigger for user creation
Mon, 06 Aug 2018 12:37:06 +0200 Tom Gottfried Use INSTEAD OF trigger for user deletion
Fri, 03 Aug 2018 17:23:55 +0200 Tom Gottfried Prevent Waterway Admins from updating users from their country
Thu, 02 Aug 2018 13:06:39 +0200 Tom Gottfried Add special role for password reset
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 12:26:54 +0200 Tom Gottfried Replace CTE with access privilege inquiry function call.
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
Fri, 27 Jul 2018 15:26:16 +0200 Tom Gottfried Add database function to check password against policy
Thu, 26 Jul 2018 19:33:42 +0200 Tom Gottfried Add view to list user profiles with role
Thu, 26 Jul 2018 15:02:19 +0200 Tom Gottfried Fix spelling
Thu, 26 Jul 2018 13:57:08 +0200 Tom Gottfried Add database function to delete role and user profile
Wed, 25 Jul 2018 18:26:54 +0200 Tom Gottfried Add database function to update role and user profile
Mon, 23 Jul 2018 17:41:31 +0200 Tom Gottfried Make map extent mandatory
Mon, 23 Jul 2018 11:29:41 +0200 Tom Gottfried Care for the fact that role attributes are not inherited
Fri, 20 Jul 2018 17:28:16 +0200 Tom Gottfried Introduce database schemas as privilege-based namespaces
Thu, 19 Jul 2018 16:37:52 +0200 Tom Gottfried Add database function to create role and user profile