Revoking select/execute on sys tables from PUBLIC

• johnnyrmtl

  Hall of Fame

  Points: 3654

  More actions

  January 24, 2013 at 9:07 am

  #288303

  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