Azure SQL - Row Level Security (RLS) Using O365 Groups

New Contributor

Is it possible to set Row Level Security using O365 Groups in an Azure SQL database table?

I have a task table with an "Assigned To" (assignedTo) column (varchar - 255). It stores the email address of an employee OR o365 Group. I need to use that value to set Row Level Security for the row.

1 Reply

@zshane15 , O365 works with Azure Active Directory, so, why not?

At first, you need to connect your Azure SQL Server instance to AAD following this topic: 

Creating a dynamic group in AAD would be a good idea:

Once done, one or more users (or a group) as a member to custom or builtin database roles with the specific permissions appropriate to that group of users. Implement your RLS.