Re: Accessing only one database on the SQL server

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

Date: Thu, 15 Jul 2004 16:12:26 -0400

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

  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • Re: upsizing to sql 2005
    ... the word SERVER in it, ... You can access to the database by multiple means (Access, ... and how does it update the SQL database with the new records in Access? ... Query Name: Arcadia - ARC ...
    (microsoft.public.access.queries)
  • Re: Linked Tables in Access
    ... any use of SQL Passthru, Linked Tables or any other use of MDB / MDE ... server, or would I also need to convert *those* queries to passthrough ... I've been trying to understand why Access database files become corrupt. ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Trouble Getting VS.Net 2003 WalkThroughs MSDE Connection
    ... Config Tool of SQL Server? ... > link to download the PUBs database. ... >>> Setup and they directed me to install MSDE and they attached a ...
    (microsoft.public.sqlserver.msde)
  • Re: Leveling by ID vs. "Standard"
    ... of this trade called Project Management. ... a database for the "Project Tables," ... to write reports on data from the server database. ... product supporting queries created with SQL. ...
    (microsoft.public.project)