Is Cell Level Security on Tables possible in Azure Synapse Analytics?

sachink 86 Reputation points
2021-07-01T15:27:21.353+00:00

Wanted to know if we can achieve Cell Level Security for tables in Azure Synapse Analytics.
Suppose there are databases in the Synapse Workspace (Spark and Sql) , so can we add Cell Level Security on these tables ?
If not , what other methods are there to enforce security on these tables.

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.
4,696 questions
0 comments No comments
{count} votes

Accepted answer
  1. Ronen Ariely 15,186 Reputation points
    2021-07-01T16:21:31.02+00:00

    Good day,

    There is no configuration for Cell Level which mean there cannot be a security in this level. You can secure the value in the cell by storing an encrypted value, but tables has rows and columns configuration so we speak about rows level or columns level security.

    Both Row-Level Security and columns level security are supported in dedicated SQL pool in Azure Synapse

    1 person found this answer helpful.

0 additional answers

Sort by: Most helpful