Necessary rights to be able to add a column with ALTER TABLE ADD column_name
- by Sorin Comanescu
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.
