Hello, I am having problems with login access in SQL Server 2000. I want to have an SQL Server login wich will be able to access only 2 of the databases in the instance. I created an SQL Login and also created mapped users to 2 existing databases. I think that when connecting with this login to the SSMS, I could not be able to access any other of the databases in the instance, but I can even query them.
I haven´t worked with SQL Server 2000, I´ve only worked with 2005, so maybe there´s something I am missing over here. If you could help me, I would really apprecciate it. Thank you very much in advance.