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

Owned by Agat Support
Last updated: Mar 22, 2022 by Yoav Crombie
1 min read

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