how can i hide my database in SQL Server?

Stephen West ~ Modified: September 24th, 2015 ~ ~ 1 Minute Reading

This topic has 3 replies, 3 voices, and was last updated 8 years, 6 months ago by Andrew Jackson.

Viewing 4 posts - 1 through 4 (of 4 total)

Author

Posts
September 24, 2015 at 12:41 pm #731 Score: 0

Stephen West
Moderator

Karma: 4 pts

I am working on SQL Server 2014 that has hundreds of databases. Is there a way to hide these databases?

September 25, 2015 at 12:52 pm #744 Score: 0
Andrew Jackson
Moderator

Karma: 1 pt
Try to execute this:
```
USE MASTER
GO
GRANT VIEW ANY DATABASE TO PUBLIC; -- turn this back on if it was off
GO
DENY VIEW ANY DATABASE TO USER_A;
GO
```
September 26, 2015 at 12:53 pm #757 Score: 0

Lincoln Burrows
Moderator

Karma: 16 pts

can i hide all user database for all logins?

October 21, 2015 at 10:27 am #854 Score: 0
Andrew Jackson
Moderator

Karma: 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
```
Author

Posts

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic.