I have some test users in my V8 umbraco setup. As admin I can only disable these users. Is there an option to delete these users? I can't seem to find this option.
I dont think you can delete users. this is because of the impact it has on the audit table and associated content items, such as who created them, last updated them etc.
It is possible, though it does require running a sql script. Below is the script I use.
DECLARE @userId AS INT = 1
UPDATE umbracoNode SET nodeUser = -1 WHERE nodeUser = @userId
UPDATE umbracoContentVersion SET userId = -1 WHERE userId = @userId
DELETE FROM umbracoLog WHERE userId = @userId
DELETE FROM umbracoUserStartNode WHERE [userId] = @userId
DELETE FROM umbracoUser2NodeNotify WHERE [userId] = @userId
DELETE FROM umbracoUser2UserGroup WHERE [userId] = @userId
DELETE FROM umbracoUserLogin WHERE userID = @userId
DELETE FROM umbracoUser WHERE id = @userId
This script removes the user completely from the system by updating the resources that can't be deleted to point at the root user and then deleting all connected table entries. If the umbracoLog table needs to be preserved, it can be changed to
UPDATE umbracoLog SET userId = -1 WHERE userId = @userId
To get the id of the user, just visit the user in the backoffice. The user's id can be seen in the url (/umbraco/#/users/users/user/{user id}).
Delete user
Hi,
I have some test users in my V8 umbraco setup. As admin I can only disable these users. Is there an option to delete these users? I can't seem to find this option.
Thanks you.
Any one?
+1 I am also looking for the same answer
I dont think you can delete users. this is because of the impact it has on the audit table and associated content items, such as who created them, last updated them etc.
I believe you can hide all disabled users.
Do you then change the name and email for the disabled user??
Now that you cant delete the user? I'm thing off GDPR laws here ?..
It is possible, though it does require running a sql script. Below is the script I use.
This script removes the user completely from the system by updating the resources that can't be deleted to point at the root user and then deleting all connected table entries. If the umbracoLog table needs to be preserved, it can be changed to
To get the id of the user, just visit the user in the backoffice. The user's id can be seen in the url (/umbraco/#/users/users/user/{user id}).
Thanks for the script, spot on!
Worked a treat. Thanks Jesse
is working on a reply...
This forum is in read-only mode while we transition to the new forum.
You can continue this topic on the new forum by tapping the "Continue discussion" link below.