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: Setting NO COUNT default on a connection only(not the entire datab
    ... In the case of ADO.NET I suggest use of the SqlClient namespace--not OleDb. ... Hitchhiker's Guide to Visual Studio and SQL Server ... ON for a specific SQL Server connection? ... We have some databases that will need to be consolidated onto a sinlge ...
    (microsoft.public.dotnet.framework.adonet)
  • 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)