create view DBO.limited_access_test as
  select branch_nbr, name from datamart.dbo.branch
GO
grant select on limited_access_test to LowAccessTest

USE master
GO
CREATE LOGIN LowAccessTest WITH PASSWORD = 'mypwd!'
GO
--------------------------------------------------------------------------
CREATE DATABASE MyDataMart
GO
ALTER AUTHORIZATION ON DATABASE::MyDataMart TO sa
ALTER DATABASE MyDataMart SET DB_CHAINING ON;
GO
USE MyDataMart
GO
CREATE USER LowAccessTest FROM LOGIN LowAccessTest WITH DEFAULT_SCHEMA = dbo;
GO
CREATE TABLE dbo.Branch (id INT)
GO
--------------------------------------------------------------------------
CREATE DATABASE MyMiniMart
GO
ALTER AUTHORIZATION ON DATABASE::MyMiniMart TO sa
ALTER DATABASE MyMiniMart SET DB_CHAINING ON;
GO
USE MyMiniMart
GO
CREATE USER LowAccessTest FROM LOGIN LowAccessTest WITH DEFAULT_SCHEMA = dbo;
GO
CREATE VIEW dbo.limited_access_test
AS
SELECT  id
FROM    MyDataMart.dbo.branch
GO
GRANT SELECT ON dbo.limited_access_test TO LowAccessTest
GO
--------------------------------------------------------------------------
-- succeeds
USE MyMiniMart
GO
EXECUTE AS LOGIN = 'LowAccessTest'
GO
SELECT * FROM dbo.limited_access_test;
GO
REVERT
GO
--------------------------------------------------------------------------
-- fails with error, as it should
USE MyDataMart
GO
EXECUTE AS LOGIN = 'LowAccessTest'
GO
SELECT * FROM dbo.Branch;
GO
REVERT
GO

USE master
ALTER DATABASE MyDataMart SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DROP DATABASE MyDataMart
ALTER DATABASE MyMiniMart SET SINGLE_USER WITH ROLLBACK IMMEDIATE;
DROP DATABASE MyMiniMart
DROP LOGIN LowAccessTest;