Share via

Row Level Security - Azure Dedicated SQL Pool

Seenuvasan, Venkatanathan 56 Reputation points
2022-07-13T07:28:41.043+00:00

We are working under azure dedicated SQL pool. I am implementing Row Level Security for the tables. I have created a security policy and predicate function. But I couldn't see the inline table functions / Security Policies created in the object explorer. Why ? Could you please guide me ? PFA screenshots.

220204-objectexplorer.png

220323-sql-version.png

Azure Synapse Analytics
Azure Synapse Analytics
An Azure analytics service that brings together data integration, enterprise data warehousing, and big data analytics. Previously known as Azure SQL Data Warehouse.
5,373 questions
0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Erland Sommarskog 121.4K Reputation points MVP Volunteer Moderator
    2022-07-13T21:00:07.297+00:00

    Azure Synapse does not have exactly the same feature set as SQL Server. I don't know off-hand whether Synpase support row-level security or inline table functions.

    Your question is a little funny. As long as you can create the function, why bother if you see them in Object Explorer or not. But I see that you are using SSMS 17.9.1, which is quite old. If the support for RLS was added to Synapse Dedicated Pools after SSMS 17.9.1, that could explain why you don't see it.

    Try downloading and installing SSMS 18.12, https://learn.microsoft.com/en-us/sql/ssms/download-sql-server-management-studio-ssms.

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.