From: esquel@sommarskog.se   
      
   Marco (noreply@no.reply) writes:   
   > In my SQL Server database (2008 R2), I have several extended   
   > properties, one of which I want to give a specific user the   
   > ability to read and update it.  Does anyone know if it would be   
   > possible to do that with sp's or views?  I don't want the user   
   > to have r/w access to any of the other extended properties,   
   > just this one.  Thanks   
      
   To modify the extended properties of an object, the user needs to   
   have ALTER or CONTROL permission on the object.   
      
   (According to the topics for sp_addextendedproperty and   
   sp_updateextendedproperty in Books Online.   
      
   --   
   Erland Sommarskog, Stockholm, esquel@sommarskog.se   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)