In synapse serverless SQL pool OR dedicated SQL pool, can row level security(RLS) be implemented based on table column value and logged in identity (azure AD group or AD user) say, I have table rows with 2 columns name and visibility:
| name | visibility |
|---|---|
| Bob | public |
| Andrew | hide |
In synapse serverless SQL pool OR dedicated SQL pool, can row level security(RLS) be implemented based on table column value and logged in identity (azure AD group or AD user) say, I have table rows with 2 columns name and visibility:
| name | visibility |
|---|---|
| Bob | public |
| Andrew | hide |
And I have an adgroupA or userA and adgroupB or userB.
When adgroupA or ADuserA querys data using "select" he should not see row with "visibilty = hide", but adgroupB or userB should see all rows irrespective of visibility. I know that Security policy and predicate function has to be created, but how to do this mapping of column value to Azure Adgroup(s) or ADuser.
Thanks in advance!!!
Row level security is not supported in azure sql seververless, it is supported in the dedicated pool
here is a link from microsoft, it would help if you had clearer requirements from help:
https://techcommunity.microsoft.com/blog/azuresynapseanalyticsblog/how-to-implement-row-level-security-in-serverless-sql-pools/2354759
