In Sql Server 2008,

Our database uses an extended properties. We noticed that a user that does not have the sysadmin role cannot read any extended properties.

What access should be granted to allow a user that has the public role to read the extended properties?

link|improve this question

75% accept rate
feedback

1 Answer

If they have been granted Select rights on the table they should have read rights on the extended properties.

link|improve this answer
feedback

Your Answer

 
or
required, but never shown

Not the answer you're looking for? Browse other questions tagged or ask your own question.