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


create     proc ujo_cred_delete
     @cred_domain   varchar(8),
     @domain_name   varchar(64),
     @principal     varchar(64)
AS

    if exists (select cred_domain from ujo_cred where (
                      (cred_domain=@cred_domain) AND
                      (domain_name = @domain_name) AND
                      (principal=@principal)))

     BEGIN
          DELETE     ujo_cred
          WHERE    ( (cred_domain = @cred_domain)
               AND   (domain_name = @domain_name)
               AND   (principal= @principal) )
          return 1
     END

     return -999 /*SUCCESS*/
GO
GRANT EXECUTE ON  [dbo].[ujo_cred_delete] TO [ujoadmin]
GO