grant access to extended properties

Giganews Newsgroups
Subject: grant access to extended properties
Posted by:  Ben (benb…
Date: 28 Aug 2006

I have a user on my database that has only "select" access
Problem is, I also want him to also be able to create/update extended
properties on tables or views, but without modifying the tables'

I played around with GRANT but apparently, a member of "db_datareader"
cannot create/modify extended properties on an object if he's not the
owner of this object. I tried making this user a member of
"db_datawriter", but it didn't work.
Nothing short of making him member of "db_ddladmin" worked... but then
this is too much, the user can now alter to delete tables: i DON'T want

Any ideas anyone? Cheers!