markknowsley
Programmer
I've installed SQL Server 2005 Management Studio Express on a colleagues PC and granted her access to only one database on one server.
When she expands the server, she can see the full list of databases on that server (although if she tries to open any of the other databases that I haven't granted rights to she gets an 'access denied' message).
Is there any way to set up SQL so that she can only see the databases that she has rights to work on - so that she won't even no that the restricted databases even exist? This is more for neatness rather than a real business need, but I just thought I would ask.
Mark.
When she expands the server, she can see the full list of databases on that server (although if she tries to open any of the other databases that I haven't granted rights to she gets an 'access denied' message).
Is there any way to set up SQL so that she can only see the databases that she has rights to work on - so that she won't even no that the restricted databases even exist? This is more for neatness rather than a real business need, but I just thought I would ask.
Mark.