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

Extended property permissions

From	Marco <noreply@no.reply>
Newsgroups	comp.databases.ms-sqlserver
Subject	Extended property permissions
Date	2013-12-20 09:40 -0800
Organization	albasani.net
Message-ID	<l91ve1$4cs$1@news.albasani.net> (permalink)

Show all headers | 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