limited permissions on test server for developers

I want to give developers limited permissions on a test sql server 2005
database. Basically they should be able to add columns to a table or
modify a columns datatype.
Create table and view definition have been granted to the developer
accounts (along with insert/update/delete), but they receive the
following error when trying to modify a table schema:
table dbo.ppir is set to read only, user doesn't have enough rights on
this table.
I am fairly new to sql server, but I did do some searching to find an
answer. I would prefer not to give them db owner permissions if
possible.
Thanks,
Andyandy wrote:
> I want to give developers limited permissions on a test sql server 2005
> database. Basically they should be able to add columns to a table or
> modify a columns datatype.
>
You could add the accounts to the "db_ddladmin" role on the database.
Regards,
lucm|||Hi Andy
They will need ALTER TABLE permission on the given table. See ALTER TABLE in
books online for more.
John
"andy" wrote:
> I want to give developers limited permissions on a test sql server 2005
> database. Basically they should be able to add columns to a table or
> modify a columns datatype.
> Create table and view definition have been granted to the developer
> accounts (along with insert/update/delete), but they receive the
> following error when trying to modify a table schema:
> table dbo.ppir is set to read only, user doesn't have enough rights on
> this table.
> I am fairly new to sql server, but I did do some searching to find an
> answer. I would prefer not to give them db owner permissions if
> possible.
> Thanks,
> Andy
>|||This worked. Thanks for the help
Andy
On Nov 16, 12:45 pm, "lucm" <l...@.iqato.com> wrote:
> andy wrote:
> > I want to give developers limited permissions on a test sql server 2005
> > database. Basically they should be able to add columns to a table or
> > modify a columns datatype.You could add the accounts to the "db_ddladmin" role on the database.
> Regards,
> lucm