question

Yash-0020 avatar image
0 Votes"
Yash-0020 asked Yash-0020 commented

Secure Azure Logic App using Azure SQL Row Level Security

How can I create a system using Azure logic app & Azure SQL with the given functionality:

Whenever a user invokes the logic app, logic app gets the uuid of the user. This uuid is passed to Azure SQL and on the basis of uuid row level security is applied. After applying the row level security, Azure SQL sends back all the generated rows to logic app.

It will be better if Azure AD can be used for row level security

azure-sql-databaseazure-logic-appsazure-ad-app-development
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

1 Answer

PramodValavala-MSFT avatar image
0 Votes"
PramodValavala-MSFT answered

This is possible and can be achieved with the following

  1. Set up authentication for Logic Apps either directing with Logic Apps or using Azure APIM.

    The APIM approach allows for a single setup for all of your logic apps and even extracting the UPN from the token, passing it directly to Logic Apps.

  2. Extract the unique ID for the user from the passed token

  3. Fetch the rows using the unique ID as shown in this example from the SQL docs.


5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.