Status: Gathering Interest (View Workflow)
Fix Version/s: None
In the table cwd_user, there should be no rows where the external_id is repeated for the same directory_id. Said in another way, the external_id should be unique for the same directory_id.
To avoid this from causing problems, we should add a unique constraint at a database level in the table cwd_user.
When two users share external_id and directory_id, the user is not able to login or update new information from the external user directory. Those actions will fail with the following error:
This also affects embedded Crowd.