SQL 2005 Users can not refresh Pivot Tables

• douglascfast

  Right there with Babe

  Points: 776

  More actions

  January 22, 2009 at 5:35 am

  #199057

  All,

  Under SQL 2000 my users could update pivot tables (Yes they were DB_Owners) under 2005 DB_Owners can do all kinds of damage. Is there some way I can give them access to update the pivot tables with out giving away the store? I thought about creating a role but I am not sure what permissions I would have to add to let them do it?

  Any ideas?

  I'm shooting in the dark here.

  Desperate Doug :0

• douglascfast

  Right there with Babe

  Points: 776

  More actions

  January 22, 2009 at 5:47 am

  #931051

  Ignore this I got two issues confused and posted this to early in the AM