Wednesday, November 30, 2016

Kentico CMS user dependency tables to delete user from CMS_User table

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>

No comments:

Post a Comment