Tuesday, August 7, 2012

Select permission has been denied on the objects





See the information

USE msdb
go
EXEC sp_helprotect
go

Notice that  syspolicy_configuration has been denied to public.  You need to grant this to public.
This is how:


USE msdb
GO
GRANT select ON syspolicy_configuration TO public
GO

USE msdb
GO
Deny select ON syspolicy_configuration TO public
GO