Grant access to the extended properties of a sql server database
- by Pierre-Alain Vigeant
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?