CREATE proc JMO_JWB_Ins (
@jwb_scdn char(65),
@jwb_name char(65),
@jwb_jno char(5),
@jwb_resn char(17),
@jwb_srt int,
@jwb_srv smallint,
@jwb_flag binary(1),
@jwb_desc varchar(255)
)
as
begin
Insert into jmo_jwb (
jwb_scdn,
jwb_name,
jwb_jno,
jwb_resn,
jwb_srt,
jwb_srv,
jwb_flag,
jwb_desc
)
Values (
@jwb_scdn,
@jwb_name,
@jwb_jno,
@jwb_resn,
@jwb_srt,
@jwb_srv,
@jwb_flag,
@jwb_desc
)
end
GO
GRANT EXECUTE ON [dbo].[JMO_JWB_Ins] TO [emadmin]
GRANT EXECUTE ON [dbo].[JMO_JWB_Ins] TO [jmoadmin]
GRANT EXECUTE ON [dbo].[JMO_JWB_Ins] TO [uniadmin]
GO