How to hide databases in SQL Server Management Studio from unauthorised users?
DENY VIEW any DATABASE TO <login>;
GO
use <your_Database>
Exec Sp_changedbowner '<login>'
这样<login>用户登陆之后,就只能看到master, tempdb, 和 <your_Database> 这三个数据库了
How to hide databases in SQL Server Management Studio from unauthorised users?
DENY VIEW any DATABASE TO <login>;
GO
use <your_Database>
Exec Sp_changedbowner '<login>'
这样<login>用户登陆之后,就只能看到master, tempdb, 和 <your_Database> 这三个数据库了