Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Revoking select/execute on sys tables from PUBLIC Expand / Collapse
Author
Message
Posted Thursday, January 24, 2013 9:07 AM


SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Yesterday @ 12:03 PM
Points: 100, Visits: 397
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
Post #1411193
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse