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 9 years, 6 months ago by Andrew Jackson.

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

Author

Posts
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 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic.