I have a database on SQL Server 2008 R2 that has two schemas, the default
dbo and a new one called
I have a view in the
Test schema called
View1 that selects from
dbo.Table1. Both schemas are owned by
I have a user called
User2 that has
SELECT permission to the
User2 can login and see
View1 but when it tries to select from it this error comes up:
The SELECT permission was denied on the object 'Table1', database 'Database', schema 'dbo'.
I thought since everything was owned by the same owner, ownership chaining would check the permission at entry point and allow the query to execute.
For kicks, I setup a similar example under a SQL Server 2012 Express database and it works fine.
Any ideas why this doesn't work?