开发者

Stop SQL Server 2008 R2 from listing databases for users without access

Is there a way to stop MS SQL Server listing databases for a user which does not have access to those databases? At the开发者_JS百科 moment if I setup a user on database A I can still see database B, C, D, E and so on, although I do not have permissions access them.


All SQL logins are members of the 'public' server-level role, which by default has the VIEW ANY DATABASE permission. This will revoke that permission :

REVOKE VIEW ANY DATABASE FROM public
0

上一篇:

下一篇:

精彩评论

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

最新问答

问答排行榜