Re: Allow users to only see their mapped DBs

Rob
See if that helps you, but I agree with Erland that currently it is not
possible
This works perfectly if the user is the owner of the database. Look
that ?

? Create a new SQL login "login1"
? Create a user named ?login1? in master database
? Grant CREATE DATABASE to login1
? While impersonating login1, create a database called ?dbtest?
? Revoke CREATE DATABASE permission from login1
? Revoke VIEW ANY DATABASE permission from PUBLIC
? Register this server as login1
? From the ?login1? session, expand database tree. Now, you should see
master, tempdb, dbtest
? Grant VIEW ANY DATABASE to PUBLIC
? From the ?login1? session, you should see all the databases




"Rob" <Rob@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:D448C3BB-551E-4D98-9FDD-62EF7D8E94A3@xxxxxxxxxxxxxxxx
Hello:

How can I can allow my users to only see the DBs their user ID has been
mapped to when they open up SSMS? When they open up SSMS today, they can
see
all the DBs; I want to restrict their view to only the DBs that their ID
is
mapped to.

TIA.


.

Relevant Pages

  • Re: Password MDF
    ... Thank you for your answer but it doesn't work because I can connect to SQL ... Server 2005 Management Studio with Windows Authetication and I still see ... "dbteste" database and all his objects, so if I distribute this database ... Create a user named "login1" in master database ...
    (microsoft.public.sqlserver.security)
  • Re: Password MDF
    ... It works perfectly if the user is the owner of the database. ... Create a new SQL login "login1" ... Register this server as login1 ...
    (microsoft.public.sqlserver.security)
  • Re: SQL Server 2005 Express Remote connection
    ... By impersonate you mean log in to SQL server as Login1? ... How do I revoke "View Any Database" from Public? ... cannot see the database from the client - just the server and the system ...
    (microsoft.public.sqlserver.server)
  • Re: SQL Server 2005 Express Remote connection
    ... It is because you are not member of sysadmin server group and/or those ... this works perfectly if the user is the owner of the database. ... Create a new SQL login "login1" ... cannot see the database from the client - just the server and the system ...
    (microsoft.public.sqlserver.server)
  • Re: defining keys and relationships in VBA
    ... Dim dbs As Database, tdf As TableDef ... Dim idx As Index ... > Dim dbs As Database, ...
    (microsoft.public.access.modulesdaovba)