Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

How to create Row Level Security in Database side

HI I am using Azure Sql server databse My sql server version:2014 please any explain how to create Row level security in database  after creating RLS in database how to use in Power BI desktop(mea...
Need Help
v-yuta-msft's avatar
v-yuta-msft
Community Support
6 years ago

Anonymous ,

 

I haven't found any doc which clarify that Azure SQL Server supports RLS. But now SQL Server 2019(on-premises) supports RLS feature, please read doc below:

https://docs.microsoft.com/en-us/sql/relational-databases/security/row-level-security?view=sql-server-ver15

 

In addtion, if you need to configure RLS for your tables, you can import the Azure SQL Server data to Azure SQL Data Warehouse and configure RLS using Azure Data Warehouse.

https://azure.microsoft.com/en-us/updates/general-availability-row-level-security-rls-for-microsoft-azure-sql-data-warehouse/

 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.