Revoking select/execute on sys tables from PUBLIC

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Programming » General » Revoking select/execute on sys tables from...

Revoking select/execute on sys tables from PUBLIC

Rate Topic

Display Mode

Topic Options

Author

Message

johnnyrmtl

Posted Thursday, January 24, 2013 9:07 AM

Valued Member

Group: General Forum Members
Last Login: Thursday, May 16, 2013 9:02 AM
Points: 70, Visits: 325

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 »

Permissions