How to use IS_MEMBER('AAD_GROUPNAME') in Azure Synapse Analytics?

user_1606161 0
Viewed 253

We are implementing row level security in Azure Synapse Analytics and we want to check if user is member of specific Azure AAD group, user can access data. As per [documentation][1]

[1]: https://docs.microsoft.com/en-us/sql/t-sql/functions/is-member-transact-sql?view=sql-server-ver15 it says this function only check windows group. Is there any work around or ETA when this features will be available?

We tried using below query but it always returns NULL

SELECT IS_MEMBER('AAD_Group_Name')

azure-synapse azure-sql-database azure
1 Answers

The document you have shared clearly mentioned that IS_MEMBER function is not supported for Azure Active Directory Groups.

You can raise the feature request here.

Alternatively, you can check this official document about How to set up access control for your Azure Synapse workspace. This will help you to understand and implement control access to a Microsoft Azure Synapse workspace using Azure roles, Azure Synapse roles, SQL permissions, and Git permissions.

user_159690410
Related