added stored procedure grant permissions to generator template