0

I have 1 database on a server that is hosting hundreds of databases, is there a way to connect to and expand only my database rather than expanding databases and seeing all of them?

Please note that this is on a server at GoDaddy, that I don't have admin access to.

dmoore1181
  • 1,793
  • 1
  • 25
  • 57

1 Answers1

1

By default, every user has the VIEW ANY DATABASE Permission. You can deny it. After that, the user can only see the databases that the user actually owns.

deny VIEW ANY DATABASE

result

If you are using SQL Server 2012 or later, you can consider using the contained database feature. A contained database is a database that is isolated from other databases and from the instance of SQL Server that hosts the database. Therefore users will be able to connect to a contained database without authenticating a login at the Server-Level. Please refer to Contained Databases.

grg
  • 5,023
  • 3
  • 34
  • 50
forkazmoden
  • 21
  • 3
  • In any other situation this would be a great answer, but this is a GoDaddy database server to which I don't have admin rights. I am surprised they give view database permissions to all users. – dmoore1181 Dec 27 '18 at 12:33
  • @beso9595 Please stick to Markdown wherever possible instead of using HTML – grg Dec 27 '18 at 12:34