复制代码 代码如下:
然后给Best库的Best用户执行
DENY VIEW any DATABASE to PUBLIC;
然后给Best库的Best用户执行
复制代码 代码如下:
ALTER AUTHORIZATION ON DATABASE::Best TO Best
搞定!!!
use master
deny view any database to [test]
ALTER AUTHORIZATION ON DATABASE::test TO test