Accessing only one database on the SQL server

From: TOM P. (TOMP_at_discussions.microsoft.com)
Date: 07/15/04


Date: Thu, 15 Jul 2004 12:41:01 -0700

I have outsider-developer who is using her own laptop (not part of domain) to work on a project, I need to get her an access to our SQL database so she can develop an application she is working on. I created new db, then new sql user, she had SQL tools on her laptop so then I registered server for here using this user I just created, then I gave access to this new created db… my question is what is the minimun requirments (right/priviladges) so she can work with this new db but prevent her with accessing other databases on the same server… other words I’m looking for scenario where she has full control over her db and no control over rest of the dbs on the same server