CREATE proc JMO_PRB_Ins (
@prb_scdn char(65),
@prb_name char(65),
@prb_jno char(5),
@prb_seq char(5),
@prb_parm1 varchar(255),
@prb_parm2 varchar(255),
@prb_parm3 varchar(255),
@prb_parm4 varchar(255)
)
as
begin
Insert into jmo_prb (
prb_scdn,
prb_name,
prb_jno,
prb_seq,
prb_parm1,
prb_parm2,
prb_parm3,
prb_parm4
)
Values (
@prb_scdn,
@prb_name,
@prb_jno,
@prb_seq,
@prb_parm1,
@prb_parm2,
@prb_parm3,
@prb_parm4
)
end
GO
GRANT EXECUTE ON [dbo].[JMO_PRB_Ins] TO [emadmin]
GRANT EXECUTE ON [dbo].[JMO_PRB_Ins] TO [jmoadmin]
GRANT EXECUTE ON [dbo].[JMO_PRB_Ins] TO [uniadmin]
GO