I am working in a joint venture of four different contractors doing one big project. Many of the application will have to use the different ADFS servers each of the four companies have. Some are desktop application connecting directly to SQL which will be hosted in IaaS. Can SQL Server grant permissions to four different domains?
DB Links can be configured with different accounts for each DB Link. But it would still be an ugly mess as far as security and management.