sql大量更改程式權限

我有一個sql , db 裡面有很條storeprocedure

sp_MSupd_dboMES_Packing_Hold
sp_MSins_dboMES_MAIN_PART_Sub
sp_MSupd_dboSYS_ESOP_Main
sp_MSdel_dboMES_Transfer_Main_Test_15
sp_MSins_dboMES_Transfer_Monitor_Special_val
sp_MSdel_dboSYS_SaveShipDate
sp_MSupd_dboMES_Transfer_Main_Test_35_Detail
sp_MSdel_dboMES_Packing_Hold
sp_MSins_dboMES_Transfer_Main_Test_25_Detail
sp_MSdel_dboSYS_ESOP_Main

我想要加這些storeprocedure 給sfcreport

use [VTSFC_Q_Kilauea_Stage]
GO
GRANT EXECUTE ON SCHEMA::[dbo] TO [sfcreport] WITH GRANT OPTION
GO
use [VTSFC_Q_Kilauea_Stage]
GO
GRANT SELECT ON SCHEMA::[dbo] TO [sfcreport] WITH GRANT OPTION
GO
use [VTSFC_Q_Kilauea_Stage]
GO
GRANT VIEW DEFINITION ON SCHEMA::[dbo] TO [sfcreport] WITH GRANT OPTION
GO

=================================================