I want to restrict a user to only one schema and to only Select privilege in tha开发者_JS百科t schema in SQL Server 2008.
A combination of DENYs and a GRANT. For example:
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]
精彩评论