Necessary rights to be able to add a column with ALTER TABLE ADD column_name
Posted
by Sorin Comanescu
on Stack Overflow
See other posts from Stack Overflow
or by Sorin Comanescu
Published on 2010-04-12T10:14:08Z
Indexed on
2010/04/12
10:23 UTC
Read the original article
Hit count: 233
Filed under:
sql-server-2005
Hi,
Could somebody point out the necessary rights to do something like
ALTER TABLE myTable ADD myColumn int NOT NULL CONSTRAINT [Constraint_name] DEFAULT ((0))
?
I assumed
grant alter on myTable to [user]
was enough but I'm getting the error message
The UPDATE permission was denied on the object 'myTable', database 'x', schema 'dbo'.
Could UPDATE rights be needed because of the DEFAULT constraint?
Thanks.
© Stack Overflow or respective owner
