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
   

- Advertisement -