Before removing the user from CMS_User table need to check below tables and delete first from here.
DELETE FROM [wethevoicekentico].[dbo].[CMS_User] WHERE UserID=<UserID>
SELECT *FROM CMS_ObjectSettings WHERE ObjectCheckedOutByUserID=<UserID>
DELETE FROM CMS_ObjectSettings WHERE ObjectCheckedOutByUserID=<UserID>
SELECT *FROM CMS_UserSettings WHERE UserSettingsUserID=<UserID>
DELETE FROM CMS_UserSettings WHERE UserSettingsUserID=<UserID>
SELECT *FROM CMS_UserSite WHERE UserID=<UserID>
DELETE FROM CMS_UserSite WHERE UserID=<UserID>
SELECT *FROM CMS_ObjectVersionHistory WHERE VersionModifiedByUserID=<UserID>
DELETE FROM CMS_ObjectVersionHistory WHERE VersionModifiedByUserID=<UserID>
DELETE FROM [wethevoicekentico].[dbo].[CMS_User] WHERE UserID=<UserID>
SELECT *FROM CMS_ObjectSettings WHERE ObjectCheckedOutByUserID=<UserID>
DELETE FROM CMS_ObjectSettings WHERE ObjectCheckedOutByUserID=<UserID>
SELECT *FROM CMS_UserSettings WHERE UserSettingsUserID=<UserID>
DELETE FROM CMS_UserSettings WHERE UserSettingsUserID=<UserID>
SELECT *FROM CMS_UserSite WHERE UserID=<UserID>
DELETE FROM CMS_UserSite WHERE UserID=<UserID>
SELECT *FROM CMS_ObjectVersionHistory WHERE VersionModifiedByUserID=<UserID>
DELETE FROM CMS_ObjectVersionHistory WHERE VersionModifiedByUserID=<UserID>
No comments:
Post a Comment