# Feature SI-156 - Preserve user external accounts data

Project: Stream Integration Basics
Status: closed
URL: https://community.openproject.org/work_packages/SI-156

## Planning

| Attribute | Value |
| --- | --- |
| Date | 2025-06-12 –  |
| Priority | Medium |
| Target versions | 16.2.0 |
| Votes |  |
| List |  |
| Roadmap |  |
| Relevance |  |

## OPEN POINTS / FEEDBACK

_No work packages_

## Use cases

_No work packages_

## Features and Chunks

_No work packages_

## Bugs and other work packages

_No work packages_

## Technical Details

| Attribute | Value |
| --- | --- |
| Module |  |
| Feature Flag |  |
| Requires doc change | No |
| Enterprise plan |  |

## Details

| Attribute | Value |
| --- | --- |
| Pull preview |  |
| Mockups |  |
| Accessibility | No |

## People

| Attribute | Value |
| --- | --- |
| Assignee |  |
| Accountable |  |
| Product manager |  |
| Feature Lead |  |
| Developers | Pavel Balashou |
| Designer |  |
| Ordered by |  |
| Signed off by |  |
| Interest by |  |

## Estimates and progress

| Attribute | Value |
| --- | --- |
| PD (min) |  |
| PD (max) |  |
| Work |  |
| Labor costs |  |

## Description

**As** a user  
**I want OpenProject to** preserve my authentication provider identity when I&nbsp;log in though another provider

**Acceptance criteria**

*   Nothing should break for users. &quot;nothing&quot; is:
    
    *   SSO log in/sign up using SAML
        
    *   SSO log in/sign up using OpenIDConnect 
        

**Technical notes**

*   Now:
    
    *   `users.identity_url` column is used to store `#{auth_provider_slug}:#{auth_provier_user_id}`. And it gets overwritten every time user logs in with another provider.
        
*   Should be:
    
    *   `users.identity_url` data moved to a separate table(e.g. `user_auth_provider_links(id, user_id, auth_provider_id, external_id)`
        
    *   when user logs in with authentication provider
        
        *   then application looks for existing link
            
            *   uses it if there is one
                
            *   creates new one if there is none
                
    *   API `users.identity_url`
        
        *   should be marked as deprecated
            
        *   on update should change existing link if possible and create a new one otherwise.
            
        *   should return last updated link
            

**Out of scope**

*   UI showing all linked accounts
