sql大量更改程式权限

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

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