Re: [scim] SCIM Synchronization Problem

"Matt Peterson (mpeterso)" <Matt.Peterson@oneidentity.com> Thu, 19 August 2021 17:33 UTC

Return-Path: <Matt.Peterson@oneidentity.com>
X-Original-To: scim@ietfa.amsl.com
Delivered-To: scim@ietfa.amsl.com
Received: from localhost (localhost [127.0.0.1]) by ietfa.amsl.com (Postfix) with ESMTP id C664E3A0F2E for <scim@ietfa.amsl.com>; Thu, 19 Aug 2021 10:33:41 -0700 (PDT)
X-Virus-Scanned: amavisd-new at amsl.com
X-Spam-Flag: NO
X-Spam-Score: -2.101
X-Spam-Level:
X-Spam-Status: No, score=-2.101 tagged_above=-999 required=5 tests=[BAYES_00=-1.9, DKIM_SIGNED=0.1, DKIM_VALID=-0.1, DKIM_VALID_AU=-0.1, DKIM_VALID_EF=-0.1, RCVD_IN_MSPIKE_H2=-0.001, SPF_PASS=-0.001, URIBL_BLOCKED=0.001] autolearn=ham autolearn_force=no
Authentication-Results: ietfa.amsl.com (amavisd-new); dkim=pass (2048-bit key) header.d=oneidentity.com
Received: from mail.ietf.org ([4.31.198.44]) by localhost (ietfa.amsl.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 5yzwEEUG2wfW for <scim@ietfa.amsl.com>; Thu, 19 Aug 2021 10:33:36 -0700 (PDT)
Received: from NAM12-DM6-obe.outbound.protection.outlook.com (mail-dm6nam12on2112.outbound.protection.outlook.com [40.107.243.112]) (using TLSv1.2 with cipher ECDHE-RSA-AES256-GCM-SHA384 (256/256 bits)) (No client certificate requested) by ietfa.amsl.com (Postfix) with ESMTPS id E97A33A0F00 for <scim@ietf.org>; Thu, 19 Aug 2021 10:33:35 -0700 (PDT)
ARC-Seal: i=1; a=rsa-sha256; s=arcselector9901; d=microsoft.com; cv=none; b=lXYJx/dgV4XQkiK1heRF21eOzOyPLaozaJr+UnAyTPeOA9rMNA8Fo+vmStaBQjXEmOGs4UZYk+C1IKYHutXNhHP5DCMA1ELdczabIe6MmTezc+Srhn/OPxVX51v08l/DY/5WSd78bYRIJCVgRymlOYOm3Xb7h7IIBI2LOIc5Sc8Ov3IketlEh4D/dgN5PkOi6oq2S2CNJTi9J3HIyDIZEuB5gE5ZW8KLi0x/TxVLBzhIg9pDRylnQv0bgMiC2+v9VYRP/9up63uVAtcvnNRp5v3BOeLIHsC4m4OdMhWq9cstArW0PCAP+oLVs3QTAHZB6dRfbg3UTbTo780vm1S2aQ==
ARC-Message-Signature: i=1; a=rsa-sha256; c=relaxed/relaxed; d=microsoft.com; s=arcselector9901; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=r/HLx+h/YXwaoFuw6OwE9y7f9bXR89Kie1hQPBysVvs=; b=Um1kiahVb+7JoVppKyU3M7uGE6Ruakub5nUPL4kbGmXbkNuGL2/K2POKQv++etDUwHd8s7b1idUdL8rQHZP0opHWVSMxk4NmtxURPKP8KRCTINaVj7tD+PThN+Mzqz5QB2IW5ln1HVNEMv6New518MMX6jF015YOKnMKoW8AZXyA3vjT+oNrBBjd9VRb3TUIUS76jyVXXM5PLm0dJ2f1u00t5YhZtwNYh9nQrB6l8i0k8vUT3bJQTrzEpUYoQomE6GrVUSJWDx/3Gl9/cO3K679YXNIEjGt5U02GKlaKF1Z2Hu7Dyu4nPLJaZwuwk8xA48tNWK91eUVBUSoFAF8IBw==
ARC-Authentication-Results: i=1; mx.microsoft.com 1; spf=pass smtp.mailfrom=oneidentity.com; dmarc=pass action=none header.from=oneidentity.com; dkim=pass header.d=oneidentity.com; arc=none
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=oneidentity.com; s=selector2; h=From:Date:Subject:Message-ID:Content-Type:MIME-Version:X-MS-Exchange-SenderADCheck; bh=r/HLx+h/YXwaoFuw6OwE9y7f9bXR89Kie1hQPBysVvs=; b=Gwulrytroi0jB2OSvJ3DqbFtJ+EM9aC3U9T/m27o4nw1+a6TdEQ/CddhlAgcifAv30WBcZzSTP2bHQz7EGchd8R5UrcRKH223rO7rloOm6+aG8FGOIdT4HJzkmi5tW4jAgmss2Bcn6aBrS6zRKwBHHtdocXypshGLhMT5NZBv9B/+dqMWCx01Porm8ScTCLQgvrjdYyWvVrm3WocxHF9sExIv7IqAvTfLYCv6am+DnWdWrianb9e/HiKE0uym9KA36+a2nLeFxp3v2nwe0NeBoARSWvFm3vFfzmUdKeUrwTVVof9QARx+jhunaOvR9qUdR1XrnWna2riUxBS/a6YAQ==
Received: from MWHPR19MB0957.namprd19.prod.outlook.com (2603:10b6:300:a4::16) by MW3PR19MB4380.namprd19.prod.outlook.com (2603:10b6:303:50::9) with Microsoft SMTP Server (version=TLS1_2, cipher=TLS_ECDHE_RSA_WITH_AES_256_GCM_SHA384) id 15.20.4415.17; Thu, 19 Aug 2021 17:33:34 +0000
Received: from MWHPR19MB0957.namprd19.prod.outlook.com ([fe80::4880:4967:c535:5783]) by MWHPR19MB0957.namprd19.prod.outlook.com ([fe80::4880:4967:c535:5783%4]) with mapi id 15.20.4415.025; Thu, 19 Aug 2021 17:33:33 +0000
From: "Matt Peterson (mpeterso)" <Matt.Peterson@oneidentity.com>
To: Danny Mayer <mayer@pdmconsulting.net>, SCIM WG <scim@ietf.org>
Thread-Topic: [scim] SCIM Synchronization Problem
Thread-Index: AQHXlD4yOJYx7decRU+u2K9sFyDQQ6t7FibQ
Date: Thu, 19 Aug 2021 17:33:33 +0000
Message-ID: <MWHPR19MB0957823E52255520BD4DB305E1C09@MWHPR19MB0957.namprd19.prod.outlook.com>
References: <e8f9d66c-f356-61b8-d38a-b5288fb9c518@pdmconsulting.net>
In-Reply-To: <e8f9d66c-f356-61b8-d38a-b5288fb9c518@pdmconsulting.net>
Accept-Language: en-US
Content-Language: en-US
X-MS-Has-Attach:
X-MS-TNEF-Correlator:
authentication-results: pdmconsulting.net; dkim=none (message not signed) header.d=none;pdmconsulting.net; dmarc=none action=none header.from=oneidentity.com;
x-ms-publictraffictype: Email
x-ms-office365-filtering-correlation-id: 13e664d2-e63d-41c3-9fb8-08d963377817
x-ms-traffictypediagnostic: MW3PR19MB4380:
x-microsoft-antispam-prvs: <MW3PR19MB4380D7832919BD4229C99608E1C09@MW3PR19MB4380.namprd19.prod.outlook.com>
x-ms-oob-tlc-oobclassifiers: OLM:10000;
x-ms-exchange-senderadcheck: 1
x-ms-exchange-antispam-relay: 0
x-microsoft-antispam: BCL:0;
x-microsoft-antispam-message-info: DX9GcvnlrnoxABEDi0Y86QZRuzVM5np6NKTddbq9Hnrbwd3+Nhg9TNowXmZwPQWAoMU4hrMwonsEDDuxO0WmximUKvuudsbEKIFhkjNt0Z+a35HZfcEYfUbvwkgM+UYM4yFWmth2DH6n06WEnYnf1PiA33f35HfcMjRoAGIxGJpBoXMkFN61xUjc7xXs2hehEylg26GKGxwE3B7tpHMYf4iEOh+/d/9u4paDMK/DSIfoffml5YuFKoiOHmALyARcyTLGDYjgHzz9hWDiyn+BoBbJJoTLV+5irfKsseu8hBRDZsp/rArdkUPocyLIY8AQ014tWpo7O7tE1qDDaPieIHFTfr2JqI4Pdu68yyxla+Y85878a4301cA+8K6czIOZtPVcb0mZ+QCg+QLILcszs7+PO3ZuzMb6Djo8z791+5WsdjML4QnIskDx2ccsFg0tZYviAqUElhym/q1933iIbQcslVmrhpUPH6RB558/QFpgoKy4x2+GQj1/VFOCwj6yKeBO8D4XmhYdURyBvM0xhMRSK00C0K5n9DTdKvI1VekRKk+G/2Hn7dWx8zv+LpDZv3BrI9zDGrMBi4gHl0xgTniu9wVpD6toZ5flGNKA9WAHX5LyTKd8h2jVMLUFqXzqoxkyJr9WtVNRhJsj2Zs7F9apMRmeJkFfccXZJ2Z/Z9AM/gn0XILhCz0OGrId0nkRq21RGxyEGfF3DHKrwWoRBFV+urZ7lMe6+2xR15ztOobcP150KAMZrXC/QNXpQ/+24+nLKwhjX/fkS2xru5QqTCRcKZbeVYnMwN8ZgLY6nxg=
x-forefront-antispam-report: CIP:255.255.255.255; CTRY:; LANG:en; SCL:1; SRV:; IPV:NLI; SFV:NSPM; H:MWHPR19MB0957.namprd19.prod.outlook.com; PTR:; CAT:NONE; SFS:(4636009)(376002)(366004)(39860400002)(346002)(136003)(396003)(110136005)(45080400002)(5660300002)(52536014)(55236004)(478600001)(8936002)(8676002)(86362001)(9686003)(55016002)(122000001)(38100700002)(83380400001)(316002)(53546011)(76116006)(966005)(33656002)(186003)(66446008)(64756008)(66556008)(7696005)(66476007)(26005)(66946007)(71200400001)(6506007)(2906002)(38070700005); DIR:OUT; SFP:1102;
x-ms-exchange-antispam-messagedata-chunkcount: 1
x-ms-exchange-antispam-messagedata-0: mQzYH9Z1wlt7pIroHC6K2KWZsImwi9aNqzt6fSaBWzhPfn6LAe0JOlUBRjXvgu2f/SRjXOuhgdmoWjo8KeKHUtJPGF+RnfKsBkQPA4PWk2yyzut1fEO/ffP2i4HsWE95jMigZzamIl1cmMzukpgAQvhfjdqRlEeCbwPRmu37ZwhaVSXk03J9osIXl6v909A375ZbD5h0UJNEYFKVWd2YSUvIp5ScF/E1p2vwwprcS2gStELJXISKcwDA8hMOoi9AGXMvzf+TgKSAB2EbDIpq4GBglx0TZkY2HLvBH4U+UuE5F0npVhwimFdn+vxmzuGksNYKmxIl/6w4VUXX9Az9LiCkvMY45qwkyh5OeKczeXUt6IvCg9rwc8utlg1dJEN/AUQ+S1YH3QS2j+FKPExFuoaOtuYvGq+fWtlg+wW/MNnG2c+mZwPcdnOGYVAClR5kXFyEgAJrwWwtVWNyzFD+zmBnEfwFuuZFXcBameWITdapTskipLu0WdNL7cTC6H/Ut5b6CqKZYSOMprmCCA8CKp28tGebIxPiWLYfgKdhYMAdawrWa4T049gxZNhAGoXGHSp73d0acTavGyXeVWLyDofub0yuy/J//sDsTvJmfGRt8VbWRSKEC1+YETOORIn6HgLElo1C3wHtBfdz9VPnT8CrweBIyOWstWZmacZy+6jyGjUZzuWI7cFjqDxdgeTFiJ8eu/tk/ZxlOZgpWtz8UExq1MelQsM+BCWGisrnu2zqMrbkxaw+vftzshfG06zHUgHuqfYUX850TlS9NPmk5Z3+ZmRQVwbFplyiO1By6vHW6tzCcS87FBku4yppfdk27794mIrprRix0oQzOUftL6bIKCdg2+42zjbFb51Ba1nx8QBfQQ46WGfZUmTujooYzktt2vGF721cdiCOxTQsJ6tG+6fEclXs3u6btqb2s0Ldp1cMrX81GyX/v2OTyoZjZ0uRWlbNp/05Mk7w1tu9UNnvbaI1aTzh7EA3qeizk9/rQD6fboRPVDsQlPpK6QaAsyCqw3ZmKuNADK+MBJpp0YOuFXkjdromwZIrEnfDAH+0wjIOxnsHJtf4BZsfrBIF2DcFxqWWmxfVXV+UZEYnIvUYi8xRKZyqN4PqzPZVv3wl4DMVjgOexdyrFYqbFIf2Sog91Wh1Jo0ZGI6u1DZ5ZiHAm3tERW6cM+curII0mjDvoRKEAZ3QpzVec8Ldh1t/HjULt+3hL17OuWTAhF8WjCGGxczw7FI2lzKwZC5ZvUAh3AfTa1PaGh5Bq0MnNLkz2LB4SmdB4UymG+Gg4Qb8A8+UQlPsuJ4q/W8MDvXks6qQNg3j0zZPBDrlVnHt+AuC
x-ms-exchange-transport-forked: True
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
MIME-Version: 1.0
X-OriginatorOrg: oneidentity.com
X-MS-Exchange-CrossTenant-AuthAs: Internal
X-MS-Exchange-CrossTenant-AuthSource: MWHPR19MB0957.namprd19.prod.outlook.com
X-MS-Exchange-CrossTenant-Network-Message-Id: 13e664d2-e63d-41c3-9fb8-08d963377817
X-MS-Exchange-CrossTenant-originalarrivaltime: 19 Aug 2021 17:33:33.7131 (UTC)
X-MS-Exchange-CrossTenant-fromentityheader: Hosted
X-MS-Exchange-CrossTenant-id: 91c369b5-1c9e-439c-989c-1867ec606603
X-MS-Exchange-CrossTenant-mailboxtype: HOSTED
X-MS-Exchange-CrossTenant-userprincipalname: +FvVvwvPuSwy1gTQRM79/YPfOCpUKeAPgbhc3ecs7WMFsC/c4NJ6GjaObl2lihwoUtDmJpd9fPmT4jdSWd8Fhg==
X-MS-Exchange-Transport-CrossTenantHeadersStamped: MW3PR19MB4380
Archived-At: <https://mailarchive.ietf.org/arch/msg/scim/cEtg22s509i8eRyZIeO_35VmXSk>
Subject: Re: [scim] SCIM Synchronization Problem
X-BeenThere: scim@ietf.org
X-Mailman-Version: 2.1.29
Precedence: list
List-Id: Simple Cloud Identity Management BOF <scim.ietf.org>
List-Unsubscribe: <https://www.ietf.org/mailman/options/scim>, <mailto:scim-request@ietf.org?subject=unsubscribe>
List-Archive: <https://mailarchive.ietf.org/arch/browse/scim/>
List-Post: <mailto:scim@ietf.org>
List-Help: <mailto:scim-request@ietf.org?subject=help>
List-Subscribe: <https://www.ietf.org/mailman/listinfo/scim>, <mailto:scim-request@ietf.org?subject=subscribe>
X-List-Received-Date: Thu, 19 Aug 2021 17:33:42 -0000

Thank you, Danny, for creating a new thread.  The following are my comments from meeting minutes (some edits):

There appears to be two use cases for "synchronization": 

  1.  Constructing and enforcing Application authorization models -  An application (acting as a SCIM client) caches users/groups data from the IdP in order to present "user/group pickers" when presenting screens used to configure the application  authorization rules (RBAC, Policy, or ACL).  Also, when the application enforces authorization, user and group data needs to be immediately available so that authorization decisions can be made quickly.

  2.  Identity Management and Governance systems - implement a canonical identity model" where all accounts and groups are represented.  This model is used to build provisioning rules and calculate separation of duty violations, attestations, and approvals etc.   Management-time evaluation of the model needs to be done efficiently without external calls to the SCIM service provider.

Both above use cases, are "client-cache" use cases that need only a "one-way" sync (from the SCIM server to the SCIM client).   To accomplish there are two distinct steps:  a) download the initial results (users/groups) and, b) keep the cached copy of these initial results (user/groups) up to date with changes that are being made on the SCIM Service provider.   

I think it could help us narrow down the list of suitable approaches if we could agree that "one-way" sync (keeping a client-side cache up to date) is our target.

--
Matt Peterson

-----Original Message-----
From: scim <scim-bounces@ietf.org> On Behalf Of Danny Mayer
Sent: Wednesday, August 18, 2021 8:34 AM
To: SCIM WG <scim@ietf.org>
Subject: [scim] SCIM Synchronization Problem

CAUTION: This email originated from outside of the organization. Do not follow guidance, click links, or open attachments unless you recognize the sender and know the content is safe.


I decided that this needs it's own thread and not be part of the meeting minutes.

I have had a great deal of experience dealing with the user account synchronization problem. Here's my view of the problems.

I will be calling one system Management Server and the other system Application Server. I found client/server labels confusing. The Management Server is what I am defining to be the server that sends updates to add/update/remove users and groups to the Application server whose account, groups and access permissions are being managed.

First some definitions of user accounts. There are usually more than one of each of these:
1. Builtin accounts
2. Special-purpose accounts
3. Employee
4. Contractor
5. Agent
6. Customer

There may be more.

1. Builtin accounts: These are accounts that applications have and there may be more than one. There is always an admin account which can do anything, for example the administrator account in Active Directory or a database admin account. The application may have more accounts for other purposes.

2. Special-purpose accounts: These may be set up to provide access to other applications, for example a SCIM request to a SCIM REST API should be handled by a special account which cannot be used to login via a UI interface and only be able to perform certain functions. In addition there may be accounts set up to listen for topics or queues on a message queue among other possibilities. Keeping separate accounts like this are important for tracking in logs and applications.

3. Employee: These are accounts that employees may login to the application.

4. Contractors: These accounts that a contractor performing work for the company may use to log into an application. Unlike Employee accounts these would have an expiration date.

5. Agent: Accounts like this are for external users who may need to manage information for their own customers. An example of this is an insurance agent logging in to handle an insurance policy for their clients.

6. Customers: These are where the customers are using the application directly. For a bank it's likely to be millions of customers. The management platform should not be involved in managing these accounts.

Let's now look at a few example applications.

1. Helpdesk
All employees and contractors will need to be able to log into a helpdesk application and enter tickets. This means loading information about all employees and contractors. For a company with only 1000 employees that's manageable. For a company with 100K employees, it's a bigger challenge.

2. Customer Support
Only employees or contractors in the department providing customer support need access plus a few other employees. In addition identified customers may need accounts.

3. Expenses
Not all employees or contractors will be submitting expenses so it may not be necessary to have accounts for all possible users. This is something that the application owner needs to decide.

Now let's look at logistics.

Bulk load:
Each application will need an initial set of accounts set up and for something like a helpdesk this could involve load 1000-100,000 accounts.
The information needed could come from either the management server or separately, say from an HR system. Many servers that I have encountered limit the number of records to something like 1000, so the pagination requirement is needed for this. Even when dealing with a limited subset of employees or contractors you can run into this need.

Synchronization
An application that is bulk-loaded above may need to be synchronized to the management server if the data did not come from the management server.

Change Management
This is really a synchronization issue as well. Changes happen all the time and new employees/contractors need to be added, terminated ones removed and updates happen all the time. The best way of dealing with this may be to set up a message queue that each application can subscribe to and they can take the needed action when it's convenient for that application. It's not the only method but it's the one I found to be the most helpful. There are two ways of doing that: 1. send the complete user information for new accounts, send just the change for updating accounts, send the ID for terminated accounts along with some meta information. The other method which I have used is just to send the ID and whether it's new, updated or terminated.

I hope this is helpful to the discussion.

Danny


_______________________________________________
scim mailing list
scim@ietf.org
https://nam12.safelinks.protection.outlook.com/?url=https%3A%2F%2Fwww.ietf.org%2Fmailman%2Flistinfo%2Fscim&amp;data=04%7C01%7Cmatt.peterson%40quest.com%7C1fb1fe803b8c439026bd08d9625553ba%7C91c369b51c9e439c989c1867ec606603%7C0%7C0%7C637648940889425726%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&amp;sdata=riJQy3jEHltc6ZFCaEe%2B6%2F2ecXN0SWBXOxIZAKLxum4%3D&amp;reserved=0