Re: Accessing only one database on the SQL server

From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 07/16/04 

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
> >
> >
> >

Relevant Pages