/****** Object:  Stored Procedure dbo.JMO_SHR_Del    Script Date: 12/1/2005 11:49:31 PM ******/


CREATE proc JMO_SHR_Del (
   @k_shr_name      char(65),
   @k_shr_key       char(12)
)
as
begin
   Delete From jmo_shr
   Where
       shr_name         = @k_shr_name      and
       shr_key          = @k_shr_key

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