Forum Discussion

ElisaT's avatar
ElisaT
Advocate II
5 years ago
Solved

Row level security security issues

Hello everyone,  I have a problem that drives me creasy. I want to use RLS on my models but the cloud security team of the headquarter of my customer block me because they consider it insecure.  Th...
Need Help
  • v-diye-msft's avatar
    v-diye-msft
    5 years ago

    Hi ElisaT 

     

    Based on the elaboration of Anonymous , Row-Level Security (RLS) simplifies the design and coding of security in your application. RLS helps you implement restrictions on data row access. and the access restriction logic is located in the database tier rather than away from the data in another application tier. The database system applies the access restrictions every time that data access is attempted from any tier. This makes your security system more reliable and robust by reducing the surface area of your security system.

    Implement RLS by using the CREATE SECURITY POLICYTransact-SQL statement, and predicates created as inline table-valued functions.

     

v-diye-msft's avatar
v-diye-msft
Community Support
5 years ago

Hi ElisaT 

 

Based on the elaboration of Anonymous , Row-Level Security (RLS) simplifies the design and coding of security in your application. RLS helps you implement restrictions on data row access. and the access restriction logic is located in the database tier rather than away from the data in another application tier. The database system applies the access restrictions every time that data access is attempted from any tier. This makes your security system more reliable and robust by reducing the surface area of your security system.

Implement RLS by using the CREATE SECURITY POLICYTransact-SQL statement, and predicates created as inline table-valued functions.

 

ElisaT's avatar
ElisaT
Advocate II
5 years ago

Thank you v-diye-msft