|Subject:||grant access to extended properties|
|Posted by:||Ben (benb…@gmail.com)|
|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!