We have an OData feed. Logins for a customer to the OData feed result in a connection to the customer's (isolated) database to retrieve their data. We would like the ability to be able to manage this by having a table list all customers, and drill down into a customer to drive the OData authentication and thus pull customer specific data via a direct query call.
Is this possible?
I don’t think it is possible. To make customers only see specific data, we can use RLS to control it.
Best Regards,
Herbert