Groups > comp.databases.ms-sqlserver > #1633

Re: Extended property permissions

From	Erland Sommarskog <esquel@sommarskog.se>
Newsgroups	comp.databases.ms-sqlserver
Subject	Re: Extended property permissions
Date	2013-12-20 23:01 +0100
Organization	Erland Sommarskog
Message-ID	<XnsA29CEA25865ADYazorman@127.0.0.1> (permalink)
References	<l91ve1$4cs$1@news.albasani.net>

Show all headers | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — Previous in thread | Next in thread | Find similar

Thread

Extended property permissions Marco <noreply@no.reply> - 2013-12-20 09:40 -0800
  Re: Extended property permissions Erland Sommarskog <esquel@sommarskog.se> - 2013-12-20 23:01 +0100
    Re: Extended property permissions Marco <noreply@no.reply> - 2013-12-20 14:26 -0800
      Re: Extended property permissions Erland Sommarskog <esquel@sommarskog.se> - 2013-12-21 00:01 +0100

csiph-web