Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

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

Re: Extended property permissions

Show all headers | View raw

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.

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