Alter Table + SQL Server

[obrienkev]

Hi all,

How do I set user permissions for Alter Table in MS SQL Server??

this is my query...

ALTER table scanning_team ADD new_page text(16) NULL

Thanks.

[tomhath]

You want users to be able to alter the tables? Add them to the db_owner role.

[obrienkev]

thanks!