How to Set Alter table rights for db user

• Sachin Bhaygude

  SSC-Addicted

  Points: 418

  More actions

  June 13, 2003 at 5:00 am

  #59142

  Hi,

  Is there any solution to give Alter table rights to database user for a particular table not for whole Database?

  Means, there is one user for database and he want to dyanamically add columns to table through code. Then how can I set permissions him for adding new columns into table.

  I do not want to set that user as db_owner Database Role. Because of this he can perform any activity in Database.

  If there is any solution, help me.

  Thanks.

  Sachin Bhaygude

  
  Sachin Bhaygude

• mccork

  SSC-Insane

  Points: 22288

  More actions

  June 13, 2003 at 6:03 am

  #461269

  You cannot give the user ALTER TABLE rights on just one table, but you can give them db_ddladmin instead of db_owner.

  
  Cheers,
  - Mark