Skip to content

A platform for community discussion. Free, open, simple.

1.3 KB
Raw Blame
# frozen_string_literal: true

class MicrosoftAuthRevoker
  def self.revoke
    # Deactivate users using microsoft as an authentication provider
    DB.exec <<~SQL
      UPDATE users SET active = false
      WHERE users.id IN (#{microsoft_user_associated_accounts_sql})
    SQL

    # Log out all users using microsoft as an authentication provider
    log_out_users

    # Revoke user API keys for users using microsoft as an authentication provider
    DB.exec <<~SQL
    UPDATE user_api_keys
    SET revoked_at = NOW()
    WHERE user_id IN (#{microsoft_user_associated_accounts_sql})
    SQL

    # Revoke API keys that are created by users using microsoft as an authentication provider
    DB.exec <<~SQL
    UPDATE api_keys
    SET revoked_at = NOW()
    WHERE created_by_id IN (#{microsoft_user_associated_accounts_sql})
    SQL

    # Remove microsoft as an authentication provider for all users
    DB.exec <<~SQL
    DELETE FROM user_associated_accounts
    WHERE provider_name = 'microsoft_office365'
    SQL
  end

  def self.log_out_users
    DB.exec <<~SQL
        DELETE FROM user_auth_tokens
        WHERE user_id IN (#{microsoft_user_associated_accounts_sql})
        SQL
  end

  def self.microsoft_user_associated_accounts_sql
    <<~SQL
    SELECT user_id
    FROM user_associated_accounts
    WHERE provider_name = 'microsoft_office365'
    SQL
  end
end