Re: SQL Server Role Security
From: Tom Moreau (tom_at_dont.spam.me.cips.ca)
Date: 12/31/03
- Previous message: Nancy Kafer: "SQL Server Role Security"
- In reply to: Nancy Kafer: "SQL Server Role Security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 31 Dec 2003 10:59:09 -0500
Add them to the db_ddladmin role.
-- Tom --------------------------------------------------------------- Thomas A. Moreau, BSc, PhD, MCSE, MCDBA SQL Server MVP Columnist, SQL Server Professional Toronto, ON Canada www.pinnaclepublishing.com/sql "Nancy Kafer" <nkafer@18004preneed.com> wrote in message news:#90l7Z7zDHA.2116@TK2MSFTNGP11.phx.gbl... I have a group of developers that I want to allow permissions to create/alter table structures in a particular database. I don't want to give them rights to alter the database itself just rights to alter the structures inside the database. I run the following command in the query analyzer connected to the development database: GRANT CREATE TABLE TO DevAdmin DevAdmin is a Windows 2K Group containing the developers. We are running SQL Server 2000. When I have one of the devlopers open Enterprise Manager and check the permissions on a table in the development database the design option is still grayed out. How can I accomplish allowing the devlopers to change the structure of tables, views, etc...without giving them db_owner rights and without allowing them to alter the database itself? Thanks. Nancy
- Previous message: Nancy Kafer: "SQL Server Role Security"
- In reply to: Nancy Kafer: "SQL Server Role Security"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
|
