Accessing only one database on the SQL server

I have outsider-developer who is using her own laptop (not part of domain) t
o 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 creat
ed, 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 accessin
g other databases on the same server… other words I’m looking for scena
rio where she has full control over her db and no control over rest of the d
bs on the same serverPlace 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|||Thanks, so this user should have only access to this particular DB, public a
nd 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...
> to work on a project, I need to get her an access to our SQL database so s
he
> can develop an application she is working on. I created new db, then new s
ql
> 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 o
n
> 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
>
>|||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?[vbcol=seagreen]
> "Andrew J. Kelly" wrote:
>
domain)[vbcol=seagreen]
she[vbcol=seagreen]
sql[vbcol=seagreen]
here[vbcol=seagreen]
db.[vbcol=seagreen]
she[vbcol=seagreen]
on[vbcol=seagreen]
full[vbcol=seagreen]
server[vbcol=seagreen]