Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  General SQL Server Forums  Database Design and Application Architecture  Revoking select/execute on sys tables from PUBLIC

Author  Topic  jrmtl Starting Member 9 Posts Posted - 2013-01-28 : 09:55:10 Hello, I have a task from an audit to remove all executes and selects from the sys schema from PUBLIC. i.e ....revoke Execute ON [sys].[sp_oledb_defdb] FROM [public] Is this safe and where can I find the Microsoft article explaiing why not to do this ? many thx