Mercurial > gemma

comparison schema/updates/1465/01.delete_user.sql @ 5502:26b7921190fa deactivate-users

Find changesets by keywords (author, files, the commit message), revision number or hash, or revset expression.
Login rights are now tracked by triggers.
author Sascha L. Teichmann <sascha.teichmann@intevation.de>
date Wed, 22 Sep 2021 16:57:45 +0200
parents 2ce85b6fcb76
children 076b6b17c4a9
comparison
equal deleted inserted replaced
5501:2ce85b6fcb76 5502:26b7921190fa
138 UPDATE users.list_users 138 UPDATE users.list_users
139 SET (email_address, report_reciever, active) = 139 SET (email_address, report_reciever, active) =
140 ('nomail@example.com', false, false) 140 ('nomail@example.com', false, false)
141 WHERE username = rolename; 141 WHERE username = rolename;
142 142
143 -- Do not allow to login any more.
144 EXECUTE format(
145 'ALTER ROLE %I NOLOGIN', rolename);
146
147 RETURN 2; 143 RETURN 2;
148 END; 144 END;
149 $$ 145 $$
150 LANGUAGE plpgsql 146 LANGUAGE plpgsql
151 SECURITY DEFINER; 147 SECURITY DEFINER;