Re: SQL Permissions question - SQL Server 2000
From: Andrew J. Kelly (sqlmvpnooospam_at_shadhawk.com)
Date: 05/20/05
- Previous message: msn_at_jrbrady.com: "Ipsec & SQL Server"
- In reply to: jdn: "SQL Permissions question - SQL Server 2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Fri, 20 May 2005 14:35:46 -0400
You can't have it both ways<g>. If they are a server admin (sa) then they
have rights to do anything to all objects in that Sql Server. If they only
need to have all rights in the individual db's then make them dbo for all
except the one db.
-- Andrew J. Kelly SQL MVP "jdn" <jdn@discussions.microsoft.com> wrote in message news:66B1D433-84CE-4832-B43E-D114C4A428B4@microsoft.com... > There's a server that I need a user to have full admin rights to, except > for > one particular database, where I only want them to have read-only rights. > > Is there a way to do this? > > TIA > > jdn
- Previous message: msn_at_jrbrady.com: "Ipsec & SQL Server"
- In reply to: jdn: "SQL Permissions question - SQL Server 2000"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
