You need to implement appropriate permissions for John and the stored procedure Marketing.GetSalesSummary