开发者

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

开发者 https://www.devze.com 2023-04-01 19:59 出处:网络
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:

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

精彩评论

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