Skip Navigation

Column-level security is now supported in Azure SQL Data Warehouse

Thursday, June 21, 2018

Azure SQL Data Warehouse now supports column-level security (CLS), an additional capability for managing sensitive data in the cloud.

You can use CLS to manage user access to specific columns in your tables in a simpler manner, without having to redesign your data warehouse. CLS eliminates the need to maintain access restriction logic away from the data in another application or introduce views for filtering out sensitive columns for a subset of users. 

To help secure your data, simply define a security policy on your table columns with the standard GRANT T-SQL statement.

For more information on column-level security in Azure SQL Data Warehouse, refer to the full blog post or the online documentation.

Free account

Get $200 in Azure credits and 12 months of popular services—free

Start free

Visual Studio

Subscribers get up to $1800 per year of Azure services

Activate now


Join Microsoft for Startups and get free Azure services

Learn more