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

"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
>
>