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
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
No comments:
Post a Comment