Hi all,

Please i am facing a challenge. In Microsoft SQL Server 2000, i know you can bring an instance of a server to your Enterprice Manager console by using New SQL Server Registration context menu. The limitation to this is that all the databases on the server will be seen (viewed) on your console. The challenge: Is there anyway of restricting the view of the database to only those that the users are given permission on?

For example, if User Kate with password Kate2007 was given permission only on Pub database in a server called TestServer. And i use New SQL Server Registration with SQL Server Authentication (uid - Kate / Pwd - Kate2007) to bring the new instance of TestServer to my PC SQL Server Enterprice Manager, is there a way of only viewing Pub database instead of all the databases in TestServer.

Please treat as urgent.

Thanks.

No, but Kate won't be able to actually get into the other databases, so while she can know they're there, the damage is at least limited.