Menu
Is there something new about row-level security in SQL Server 2012?
In 2008 and below the only way was using Views, in 2012 they announced something like Row Level Security in Tabular Models, does this have any relation to RLS over tables?
Are there any news on RLS in 2012 in general?
832
Row-Level Security enables you to use group membership or execution context to control access to rows in a database table. Row-Level Security (RLS) simplifies the design and coding of security in your application. RLS helps you implement restrictions on data row access.
You apply row-level data security access controls in two steps. First, create an RLS filter function that determines who can view which data. Second, create a security policy at the table-level, using it to implement row-level security access control.
The system automatically chooses the appropriate lock granularity. A row is the smallest resource that can be locked. The support of row-level locking includes both data rows and index entries. Row-level locking means that only the row that is accessed by an application will be locked.
There is still no support out of the box. There are a white paper, Implementing Row- and Cell-Level Security in Classified Databases and an accompanying toolkit you can use to implement RLS, CLS based on labels, which were updated to cover SQL Server 2012.
191
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
