> And then the order table will need to set user ids as a foreign key and you will have two sources of truth lol
Why should your order manager service be tightly-coupled to your IAM service when the only responsibility it has is to store a single ID?
Will be fun when you decide that you want to have organizations to be linked to orders instead of users.
All this to say, data management and having more than one source of truth complicates your world a lot. The responsibility for writing the data has to be solved at the appropriate layer: only one entity writing it.