Microsoft SQL Server permission chaining
Many times, views are used as a security object; Granting select on a given view instead of the underlying table(s). Now if this view happens to cross schemas you might get an error saying the user does not have select permission on the underlying ta...
josefrichberg.com1 min read