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

Extended property permissions

Path	csiph.com!usenet.pasdenom.info!news.albasani.net!.POSTED!not-for-mail
From	Marco <noreply@no.reply>
Newsgroups	comp.databases.ms-sqlserver
Subject	Extended property permissions
Date	Fri, 20 Dec 2013 09:40:26 -0800
Organization	albasani.net
Lines	6
Message-ID	<l91ve1$4cs$1@news.albasani.net> (permalink)
Mime-Version	1.0
Content-Type	text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding	7bit
X-Trace	news.albasani.net RHwKutJiAEUqmErLG5ojRXwbicXuV1Tjr35mB8js/jWZiVgE1n17OoNO2OTm9W5wPBplsdPta08qfrjE1sfYKQ==
NNTP-Posting-Date	Fri, 20 Dec 2013 17:40:17 +0000 (UTC)
Injection-Info	news.albasani.net; logging-data="ZoQ9xdNVx76XR6pnAUJF9duy4foe7CqgoJubdGunDtlFLloP1AKBITS16iZ7lL1hpKo01jz+8jgLTOkglGedj073KpM7+k07iv50A+3ptICE/SZxl4BNg7FXXVcYaSbm"; mail-complaints-to="abuse@albasani.net"
User-Agent	Mozilla/5.0 (Windows NT 5.1; rv:17.0) Gecko/20130620 Thunderbird/17.0.7
Cancel-Lock	sha1:5wkBdjvEeQUlZ18kjnK9SXOl6o4=
Xref	csiph.com comp.databases.ms-sqlserver:1632

Show key headers only | View raw

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

Back to comp.databases.ms-sqlserver | Previous | Next — 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