SQLblog.com - The SQL Server blog spot on the web
Row Level Security and Indexed Views
I was giving my Row Level Security session last weekend for the Richmond User Group ( @RichmondSQL http://rva.pass.org/) and a question came up (ok, so I technically asked the question). How does the feature work with indexed views? Generally speaking, the answer turned out to be obvious. You can apply a RLS Security Policy to a view that has an index on it, but not to a table that is referenced by an indexed view. Example code: Create a table CREATE SCHEMA Demo; GO CREATE TABLE Demo.SaleItem...(read more)
No comments:
Post a Comment