Any Option for SaaS Application Database.

[jagatreypatelgyrus]

Hi,

Thank You for the reply in Issue channel.

As you suggested I started new Discussion. You can close the same topic from Issue channel.

Let me explain more.

We have SaaS application. And have single DB that have different customer's data. Now we planned to open API endpoint that can be used by different customer to retrieve their individual data.

Just for your information, we didn't have SCHEMA base separation in our Database.

Also, we didn't want to setup any Manual process to create separate users for each and every customer. We need something automated process by which client can setup their access and retrieve their data themself without any manual interaction from our end.
Hope this help you to understand our requirement.

Thank You.
Jagatrey Patel
jagatrey.patel@gyrus.com

[RubenCerna2079]

Hi @jagatreypatelgyrus is the data of each customer in its own table or view? Or is the information of all the customers mixed between all the tables and you want to retrieve specific rows of data? I am asking this because I think there is a way to solve your issue, but it changes depending on how you manage your customers data.

[jagatreypatelgyrus]

Hi @RubenCerna2079 ,
Our data are mixed in tables. We have some columns in each tables and the base of that columns value we can differentiate the individual customer's data.
Thank You
Jagatrey Patel

[RubenCerna2079]

If you are using MSSQL then you should be able to set row level security for your database by using the set-session-context property.

The following link gives information on how this property works,
https://learn.microsoft.com/en-us/azure/data-api-builder/reference-database-specific-features#azure-sql-and-sql-server

And this link shows how to set the row level security inside the database,
https://learn.microsoft.com/en-us/azure/data-api-builder/concept/security/row-level-security

If you have any more questions about how to set it up let me know.

[RubenCerna2079]

Hi @jagatreypatelgyrus if my previous answer helped you please let me know so that we can close this discussion

[jagatreypatelgyrus]

Hi @RubenCerna2079 ,

Thank You for the checking and sorry for the late response.

Actually we need to check the possibilities that you suggested and currently it takes time.

Will check and let you know if any, mean while you can close this. We will reply once we have something to ask.

Thank You.
Jagatrey Patel.