Home » Reply » Reply To: how can i hide my database in SQL Server?

Reply To: how can i hide my database in SQL Server?

Andrew Jackson ~ Modified: October 21st, 2015 ~ ~ 1 Minute Reading

Home Forums how can i hide my database in SQL Server? Reply To: how can i hide my database in SQL Server?

#854 Score: 0
Andrew Jackson
Moderator
1 pt

Use below T-SQL for Deny to view databases

REVOKE VIEW ANY DATABASE TO [Database1]
go
REVOKE VIEW ANY DATABASE TO [Database2]
go