How to hide unauthorized databases with SQL 2005?

Hi,

I have configure permission for userA and he can access only one database.
When user estabilish the connection via management studio, though he cannot
access other databases, he can see them. Is it possible to hide other
databases for userA?

Appreciate all your reply.

Shane


.

Relevant Pages

  • Re: Great Restaurant in Miami - next time you are in South Florida
    ... Zakariya, in front of databases ... cosmetic and immediate, fixs in connection with it, noticing ...
    (sci.crypt)
  • Re: IIS6 Dynamic pages execusion problem
    ... I'm sure that connection objects to databases are closed probably and the ... "Rany M. Sabry" wrote in message ... > I have a number of Web Servers running IIS6 hosted on Windows 2003 ...
    (microsoft.public.inetserver.iis)
  • Re: Switching ODBC Oracle databases
    ... Also is there something in the connection string I am using that causes ODBC ... "Lynn Trapp" wrote: ... databases in the 10th and then you would only have to create the single ODBC ...
    (microsoft.public.access.externaldata)
  • Re: Changing a DataAdapter connection
    ... Assign new connection to adapter's command instances ... > I have several servers hosting SQL databases. ... > I have a ComboBox that let me chose the server, ...
    (microsoft.public.dotnet.general)
  • Re: Returning a closed recordset...
    ... You can also set the Initial Catalog on the Connection to switch databases ... > However, when I run this in my code, it simply returns a recordset whose ... > with oRs ...
    (microsoft.public.vb.database.ado)