The SELECT permission was denied on the object 'tables', database 'mssqlsystemresource', schema 'sys'.

2012-10-12T13:07:00.000-07:00

use master
go
DENY SELECT ON sysdatabases TO public
DENY SELECT ON INFORMATION_SCHEMA.COLUMNS To public
DENY SELECT ON INFORMATION_SCHEMA.PARAMETERS To public
DENY SELECT ON INFORMATION_SCHEMA.TABLES To public
DENY SELECT ON INFORMATION_SCHEMA.VIEWS To public

use FDA
DENY SELECT ON [sys].[columns] TO public
DENY SELECT ON [sys].[tables] TO public
DENY SELECT ON [sys].[syscolumns] TO public
DENY SELECT ON [sys].[sysobjects] TO public
DENY SELECT ON [sys].[objects] TO public
DENY SELECT ON [sys].[syscomments] TO public

GRANT SELECT ON [sys].[columns] TO public
GO
GRANT SELECT ON [sys].[tables] TO public
GO
GRANT SELECT ON [sys].[syscolumns] TO public
GO
GRANT SELECT ON [sys].[sysobjects] TO public
GO
GRANT SELECT ON [sys].[objects] TO public
GO
GRANT SELECT ON [sys].[syscomments] TO public
GO

SELECT permission was denied on the object tables

The SELECT permission was denied on the object 'tables', database 'mssqlsystemresource', schema 'sys'.