Re: Accessing only one database on the SQL server

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

Date: Thu, 15 Jul 2004 15:02:01 -0700

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

  • Re: Newbie Help!
    ... I agree with Andrew. ... Senior Database Administrator ... I support the Professional Association for SQL Server ...
    (microsoft.public.sqlserver.server)
  • RE: Fulltext failure on a 2 node cluster
    ... Server full-text search resource online: "SQL Cluster Resource 'Full Text' ...
    (microsoft.public.sqlserver.clustering)
  • Re: HELP PLEASE ~ ???
    ... You mentioned that it went ahead and added a SQL ... SQL Server 2000 database for all my data. ... find the connectionString in the newly recreated SQLExpress database. ... The connection string specifies a local Sql Server Express instance ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: New Server RAID setup
    ... Andrew thank you for all your help! ... Ideally yes it would be best to have IIS etc on another ... > sharing resources with SQL Server. ... > server as SQL for performance & security reasons. ...
    (microsoft.public.sqlserver.setup)
  • Re: Multi-Channel Raid VS SAN Storage
    ... A 5~6 years old server is a very old server. ... As I mentioned, the server is one node in a cluster environment, and SQL is ... We actually are running RAID 1+0 and our aplication is definately more ... needs it's own SAN device, or at least a dedicated IO channel on the SAN. ...
    (microsoft.public.sqlserver.setup)