Removing a single user from NAV 2013 through SQL

afarr

More than once, I have tried to remove a user in NAV 2013 and got an error message saying (roughly) "The user cannot be deleted because the user is already logged in".
I get that message even when the user is actually NOT logged in.

I therefore found the following SQL commands useful.
I just need to replace DatabaseName and atualSID with the appropriate values.
I'm pasting the commands here because there are 8 different tables to delete from, and the fields sometimes have different names.


USE [DatabaseName]
GO

DELETE
FROM dbo.[User]
WHERE [User Security ID] = 'actualSID'

DELETE
FROM dbo.[User Property]
WHERE [User Security ID] = 'actualSID'

DELETE
FROM dbo.[User Personalization]
WHERE [User SID] = 'actualSID'

DELETE
FROM dbo.[User Metadata]
WHERE [User SID] = 'actualSID'

DELETE
FROM dbo.[User Default Style Sheet]
WHERE [User ID] = 'actualSID'

DELETE
FROM dbo.[Page Data Personalization]
WHERE [User SID] = 'actualSID'

DELETE
FROM dbo.[Access Control]
WHERE [User Security ID] = 'actualSID'

detlef

If you delete the user from User Personalisation first (run table from Dev environment to see SID), you wont get an error message