(SQL) Tip of the Day: Row Level Security on SQL Azure Database

Today’s Tip…

Row level security allows you to control access to rows in a table based on the user that is executing that query. Row-Level Security (RLS) simplifies the design and coding of security in your application. RLS enables you to implement restrictions on data row access. For example, ensuring that workers can access only those data rows that are pertinent to their department, or restricting a customer's data access to only the data relevant to their company.

You can read about using and setting up Row Level Security for SQL Azure here: https://msdn.microsoft.com/en-us/library/dn765131.aspx