How to restrict a user access to objects of only one schema in SQL Server 2008?

Question

I want to limit the user to only one schema and select only the privilege in this schema in SQL Server 2008.

Answer 1

Combination of DENY and GRANT. For instance:

DENY SELECT ON schema::[dbo] TO [user_name] DENY SELECT ON schema::[other_schema] TO [user_name] GRANT SELECT ON schema::[safe_schema] TO [user_name]