Portal user locked out - Unlock Site Security for a SaaS client

In some cases users might get locked out from being able to access the admin portal because of wrong settings saved in the site security settings.

In such case perform the following steps

1. Execute the following query in the database

   DECLARE @systemSettingsCategory INT = (SELECT [ID] FROM [SETTINGSCATEGORY] WHERE [CategoryName] = N'settings_system_category_header'); DECLARE @userAdministrationSettingsCategory INT = (SELECT [ID] FROM [SETTINGSCATEGORY] WHERE [CategoryName] = N'settings_user_administration_category_header'); UPDATE [SETTINGS] SET [Value] = N'[]' WHERE [Category] = @systemSettingsCategory AND [Name] = 'AccessPortalSiteSecurityPermissions' UPDATE [SETTINGS] SET [Value] = N'Yes' WHERE [Category] = @userAdministrationSettingsCategory AND [Name] = 'RequireSignInForAdmin'

2. Reset the IIS

3. Update the customer