Can't make changes in the design mode of DB

• Cobra-1032610

  SSC Veteran

  Points: 239

  More actions

  March 3, 2009 at 9:15 pm

  #201021

  Hi All,

  The issue is that, there is a user who has db_datareader,db_datawriter,db_ddladmin and Execute permissions on a DB. But this user is not able to make changes in the design mode. Is this related to VIEW DEFINITION permission, I'm not sure, please throw some light on this!!

  Guys, please advice. Thanks in advance!!!

• John H Marsh

  SSChampion

  Points: 11671

  More actions

  March 3, 2009 at 10:57 pm

  #952874

  Hello,

  I think this article describes the issue you are experiencing. It also suggests a possible solution:-

  http://sqlug.be/blogs/por_dentro_sql/archive/2007/10/20/management-console-and-db-ddladmin.aspx

  Regards,

  John Marsh

  www.sql.lu
  SQL Server Luxembourg User Group

• Cobra-1032610

  SSC Veteran

  Points: 239

  More actions

  March 3, 2009 at 11:28 pm

  #952883

  Thanks so much John! Let me see if it resolves my issue.