Display only the Accessible Databases

• Abhilash T

  Mr or Mrs. 500

  Points: 516

  More actions

  June 17, 2012 at 7:52 am

  #276417

  Hi all,

  There any option to hide the inaccessible Databases for a user?

  Or Show only the databases those can access.

  I tried in owner of User. The problem is owner can access to other DBs too, that are not visible.

• thadeushuck

  Ten Centuries

  Points: 1367

  More actions

  June 18, 2012 at 7:46 am

  #1502238

  I am assuming you mean within SQL Server management studio (SSMS) ?