开发者

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

开发者 https://www.devze.com 2023-02-09 05:31 出处:网络
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,

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

精彩评论

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