I have a SQL Server host running SQL 2005 9.00.4294 x86 Standard Edition running on Windows build 2195 SP4. My client workstation is running only SQL Server 2005 workstaion components. When a user of the host who has db_owner access attempts
to view the properties of a table by right-clicking the table and then clicking Properties, the following error mesage is displayed:
"The EXECUTE permission was denied on the object "xp_instance_regread", database 'mssqlsystemresource', schema 'sys'
For security purposes, I do not want to grant execute on xp_instance_regread to these users. Does anyone know of a workaround that will allow members of db_owner to access table properties using the abovementioned method and does not
require execute access to be granted?
View Complete Post