Stored Procedures [dbo].[JMO_PRT1_Del]
Properties
PropertyValue
ANSI Nulls OnYes
Quoted Identifier OnYes
Parameters
NameData TypeMax Length (Bytes)
@k_prt_scdnchar(65)65
@k_prt_namechar(65)65
@k_prt_jnochar(5)5
@k_prt_qualchar(5)5
@k_prt_seqchar(5)5
Permissions
TypeActionOwning Principal
GrantExecuteemadmin
GrantExecutejmoadmin
GrantExecuteuniadmin
SQL Script
/****** Object:  Stored Procedure dbo.JMO_PRT1_Del    Script Date: 12/1/2005 11:49:25 PM ******/


CREATE proc JMO_PRT1_Del (
   @k_prt_scdn      char(65),
   @k_prt_name      char(65),
   @k_prt_jno       char(5),
   @k_prt_qual      char(5),
   @k_prt_seq       char(5)
)
as
begin
   Delete From jmo_prt1
   Where
       prt_scdn         = @k_prt_scdn      and
       prt_name         = @k_prt_name      and
       prt_jno          = @k_prt_jno       and
       prt_qual         = @k_prt_qual

end
GO
GRANT EXECUTE ON  [dbo].[JMO_PRT1_Del] TO [emadmin]
GRANT EXECUTE ON  [dbo].[JMO_PRT1_Del] TO [jmoadmin]
GRANT EXECUTE ON  [dbo].[JMO_PRT1_Del] TO [uniadmin]
GO
Uses