From: noreply@no.reply   
      
   On 12/20/2013 2:01 PM, Erland Sommarskog wrote:   
   > 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.   
      
   Yes I know that, thanks.  But I'm wondering if there is a way,   
   perhaps through a stored procedure or a view, to give a user   
   read and update permissions to one specific extended property only.   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)