How to create API that allow users to only access data they are authorized too see? That could be a very complex task, as managing security and is a very delicate and complex challenge. Azure SQL provides native support to Row Level Security that can help you create secured API with just a few lines of code. In this sample in Python, but would work as well with .NET, as the Row Level Security feature is in Azure SQL, I'll guide you through the process...and as you can see it only takes a few minutes. Watch the video and you'll realize that without Azure SQL Row Level Security support, the task would have been much, much, harder.
The complete sample, along with a detailed articles are available here:
GitHub Repo: https://github.com/Azure-Samples/azur...
On this page of the site you can watch the video online Creating API to access data securely with Python, Flask and Row Level Security with a duration of hours minute second in good quality, which was uploaded by the user The Azure SQL Developer 23 April 2020, share the link with friends and acquaintances, this video has already been watched 1,806 times on youtube and it was liked by 20 viewers. Enjoy your viewing!