For security purposes, it is recommended that you revoke permission to execute some of the stored procedures that are created by default in SQL server.
The following SQL command can be used to revoke permission:
REVOKE EXECUTE ON [stored procedure] FROM public;
The command will block the public server-level role from executing stored procedures. It should be used to block the following procedures:
NOTE: Some extended procedures are used by Security Center features, such as backups or health monitoring of the database sizes.
The following extended stored procedures are used by Security Center features, for items such as backups or health monitoring of database sizes:
The execute permission on these procedures should be given to the account that is used by Security Center to connect to the database. To provide this permission, use the following command:
GRANT EXECUTE ON [stored procedure] TO [Security Center principal]