Restrict Access to SQL Server Data using a Facade Database

This article describes a way to create a Facade Database to provide restricted access to specific tables in your databases to specific users without granting direct access to any of the underlying databases/tables.