Re: SQL Server Role Security
From: Nancy Kafer (nkafer_at_18004preneed.com)
Date: 12/31/03
- Next message: Jasper Smith: "Re: Password protected BAK Files"
- Previous message: Steve Thompson: "Re: Password protected BAK Files"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Date: Wed, 31 Dec 2003 12:33:07 -0600
Thanks Tom. That did exactly what I wanted.
"Tom Moreau" <tom@dont.spam.me.cips.ca> wrote in message news:OeC0Jc7zDHA.2580@TK2MSFTNGP09.phx.gbl...
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
- Next message: Jasper Smith: "Re: Password protected BAK Files"
- Previous message: Steve Thompson: "Re: Password protected BAK Files"
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ] [ attachment ]
Relevant Pages
|
