Re: Accessing only one database on the SQL server
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: Thu, 15 Jul 2004 18:40:05 -0400
Yes that is correct. If they only belong to a database role they will not
have permissions outside that database.
-- Andrew J. Kelly SQL MVP "TOM P." <TOMP@discussions.microsoft.com> wrote in message news:AB24E7E1-4095-450B-8A87-97A4C7CD02DD@microsoft.com... > Thanks, so this user should have only access to this particular DB, public and db_owner roles no server role whatsoever... right? > > "Andrew J. Kelly" wrote: > > > Place her in the dbo role for that database only and she should not have > > rights to any other unless you give them to her. > > > > -- > > Andrew J. Kelly SQL MVP > > > > > > "TOM P." <TOMP@discussions.microsoft.com> wrote in message > > news:F7748074-FA4B-4C87-851A-82E5E2D5A4E6@microsoft.com... > > > 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 > > > > > >