开发者

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

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]
0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜