让用户只能看到自己有权限的数据库

设置public不能查看无权限的数据库
DENY VIEW any DATABASE TO PUBLIC;

授权
Grant VIEW any DATABASE TO PUBLIC;

http://www.cnblogs.com/huangtailang/p/4209180.html

http://www.cnblogs.com/yangyunzhou/archive/2012/12/28/2837933.html

 

权限的配置参考这个

http://blog.sina.com.cn/s/blog_13554ebc70102wi3h.html

 

权限配置了User Mapping之后，还是无法看到。

尝试用命令来分配权限，会有以下错误提示，只能先取消

The proposed new database owner is already a user or aliased in the database.

然后再通过命令来配置

ALTER AUTHORIZATION ON DATABASE::CL_LS_CMS_ECRP TO chuck

 

作者:Chuck Lu    GitHub